Excel/Excel finding all first occurances
I have a query that I have been searching the internet to find the answer to but to no avail. You have helped me once before so I hope you are able to help me again.
I want to create a formula which will look at column A to find the first occurance of each ID number and then examine column B.
I am using Excel 2003.
Below is an example table.
I would like a formula for the following:
If the first occurance of ID (in column A) equals red (column B) then "red", If the first occurance of ID equals yellow then "yellow", If first occurance of ID does not equal red or yellow then "other". Subsequent occurances of ID can be ignored.
I hope this makes sense. Please be gentle with me as I am not a very confident Excel user.
It is unclear to me where you want the results or how you want to search. I will assume that
so in C2 put in
now drag fill this formula down column C next to your data.
In my test worksheet with test data I generated, I got a result like this:
2222 Green Other
3333 Yellow Yellow
1111 Red Red
Hopefully that is what you want.
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here