| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
RANGE EXCEL copy cell that meets criteria in a range
on a data sheet all data is imputed - sheet 1
I have a range of cells ie a7 to a2028 with dates in them next range of cells b7 to b2028 has either the letter s or c in them next range of cells c7 to c2028 has numbers in them I want to have another sheet (sheet 2) that takes information from todays date and either s or c in column b ie if a1 to a2028 equals march 26,2008 and b1 to b2028 equals c then take the value in column c that is in the same row as the criteria met above I tried using the below formula but get 0 for a response =IF(AND('Ser Data'!A7:A2120=TODAY(),'Ser Data'!B7:B2120="s"),'Ser Data'!C7:C2120,0) Please help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy range and paste into every 3rd cell of new range | New Users to Excel | |||
| Copy row details where cell value meets certain criteria | Excel Worksheet Functions | |||
| copy row to new sheet where cell value meets criteria | Excel Discussion (Misc queries) | |||
| Find dates in a range; then sum values in that range by a criteria | Excel Discussion (Misc queries) | |||
| Formula to return ADDRESS of cell in range that meets criteria | Excel Worksheet Functions | |||
Threaded Mode
