| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to return a set of numbers in column A
Ok you are right. I want to return a number in call A1 if cell B10, and keep
the same conditional formula for A2 but this time A2 will equal A1+1 and so on. I hope that this clarifies it. "Toppers" wrote: An example would help to clarify what you mean by "certain conditions" and numbers being consecutive. "Welby" wrote: Hi, I am working in excel 2007. I want to know how to get Column A to return a reference number if Column B has certain conditions. P.S. the numbers in column A has to be consecutive (Let's say, 3001, 3002, 3003, 3004) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LOOKUP and return the column heading for IF/THEN return for False | Excel Discussion (Misc queries) | |||
| sort and return column numbers | Excel Worksheet Functions | |||
| In a column of numbers, how do I return the last non-zero number? | Excel Discussion (Misc queries) | |||
| Get different numbers to return text?? | Excel Worksheet Functions | |||
| How to compare 3 numbers and return value | Excel Worksheet Functions | |||
Linear Mode
