Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Repeat cell data for specific condition
Hello:
I'm certain that this has probably been covered (in one form, or another), but am under short time constraints, and really can't search (please excuse....) I have a table in which I track customer orders. Column B=Account Code Column I=Customer Reference # Column X=Purchase Order # For a specific account code (D1EFM), the Column X should reflect exactly what column I states on the same row. I believe that it would be something like: if B:B="D1EFM",return value of column I, else leave it blank. I am unsure of the correct syntax, however, and would appreciate all help! TIA, Sandi |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to repeat one cell specific times to form an array? | Excel Worksheet Functions | |||
Copy data in one cell to blank cell immediately below, repeat | Excel Worksheet Functions | |||
display a range of data when triggered by a specific condition | Excel Worksheet Functions | |||
How do I repeat rows at the top of specific pages (Excel)? | Excel Discussion (Misc queries) | |||
Repeat Cell Data | Excel Worksheet Functions |