ExcelBanter - how to return a set of numbers in column A

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how to return a set of numbers in column A (https://www.excelbanter.com/excel-worksheet-functions/154630-how-return-set-numbers-column.html)

Welby

how to return a set of numbers in column A

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 02:16 PM.