Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
3 criteria must exist in adjoining cells then rtn val from 4th
i need to drop data into a spreadsheet, from this data I wish to
automatically extract from this spreasheet and populate into another spreadsheet values, the data will in succesive columns (clm) have, in the 1st clm the customer identity, could be numeric say 350, alphanumeric say col001 or just alpha say roy; 2nd clm will have a four digit No., the 3rd clm a six digit No., being a date. The first column against any customer I.D. can have a combination of these four digit numbers and dates. I wish then to have in place in my target cell specific individual formulas that will identify and require three adjoining cells on the same row to match the criteria in that cell, i.e. say col001 and say 0291 and say 200512,if these exist then return the value in the same row from the 4th clm; if not enter zero.Thanks for any HELP |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumif function does not add up cells, even when criteria is blank | Excel Worksheet Functions | |||
add a column only if 5 other cells on the row satisfy criteria | Excel Worksheet Functions | |||
Counting the number of cells meeting conditional formating criteria | Excel Worksheet Functions | |||
counting cells (COUNTIF) based on two or more criteria | Excel Worksheet Functions | |||
sum cells with criteria | Excel Worksheet Functions |