Excel Formula - URGENT | TechRepublic

Question

Creator

Topic
February 11, 2014 at 12:15 pm #2135788

Excel Formula – URGENT

Locked

by samtitus · about 9 years, 3 months ago

Tags: Windows

I need a formula to do the following look up a name in column A1 on sheet1 then look up that name on sheet2 in column A1:A6 when it finds that name it need to look in column B to find a date, if that date matches January 2014 it has to look up the value in column c and average all the values it finds for that person in January 2014

This conversation is currently closed to new comments.
Creator

Topic

All Answers

Author

Replies
- February 11, 2014 at 12:15 pm #2424807
  
  Clarifications 1392120912
  
  by samtitus · about 9 years, 3 months ago
  
  In reply to Excel Formula – URGENT
  
  Clarification dummy post @ 1392120912
- February 12, 2014 at 3:07 am #2424805
  
  You asked this same question 6 days ago.
  
  by Wizard57M-TR · about 9 years, 3 months ago
  
  In reply to Excel Formula – URGENT
  
  then asked in reply to yourself as “urgent”. You probably are not going to receive an answer, other than read your textbooks and use the built in “help” that comes with Excel.
  - February 17, 2014 at 10:22 am #2424772
    
    My question of 6 days ago
    
    by samtitus · about 9 years, 3 months ago
    
    In reply to You asked this same question 6 days ago.
    
    ok, so how do I get someone to help me
Author

Replies

Viewing 1 reply thread

Start or Search

Start New Discussion

The importance of diversity and inclusion in any given organization cannot be overstated. It establishes a level playing field, brings together people with different backgrounds, perspectives, traditions and ideas and enriches company culture by ensuring fairness and tolerance. This helps build a more effective and collaborative workforce which enables the business to run in a ...

Software development is a complex process that involves a specific series of steps (known as the development lifecycle) to transform a concept into a deliverable product. The steps involved with creating the finished product must be carefully adhered to yield the best results, reduce inefficiencies and maximize customer satisfaction. The purpose of this policy from ...

Cybersecurity demands and the stakes of failing to properly secure systems and networks are high. While every organization’s specific security needs form a unique and complex blend of interconnected requirements, numerous security fundamentals almost always apply to each of these groups. It stands to reason that cybersecurity pros who effectively identify network and systems risks ...

Windows

Question

Excel Formula – URGENT

All Answers

Clarifications 1392120912

You asked this same question 6 days ago.

My question of 6 days ago

Diversity and inclusion policy

Development lifecycle policy

Checklist: Network and systems security

How to host multiple websites on Linux with Apache