| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating function to insert data based on criteria
I have a spreadsheet with three columns and numerous rows. If Column B meets
a certain criteria, and Column C meets a certain criteria, I'd like the reference number in Column A to be inputted into a different part of the spreadsheet. How do I do this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Creating function to insert data based on criteria
=IF(B1=Criteria,if(C1=Criteria,A1,""))
-- Brevity is the soul of wit. "Tami" wrote: I have a spreadsheet with three columns and numerous rows. If Column B meets a certain criteria, and Column C meets a certain criteria, I'd like the reference number in Column A to be inputted into a different part of the spreadsheet. How do I do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function - counting based on criteria | Excel Worksheet Functions | |||
| Pull data from another sheet based on certain criteria | Excel Discussion (Misc queries) | |||
| Varying left criteria based on 1st Letter....If Function? | Excel Discussion (Misc queries) | |||
| SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Linear Mode
