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) |
All times are GMT +1. The time now is 10:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com