Forum Discussion
INDIRECT Formula??
I had already done things the hard way for the first few numbers. So, what I am needing is for each set of dates (separated by yellow highlighted) I need each number in column A to be beside each set of dates (see 626 for example). I really don't want to have to fill in each # as there are a lot. Columns D and E I need to stay as they are, especially the formula in column E. I hope this makes sense. Below is a small example to help explain what I'm needing.
| A | B | C | D | |
| 1 | 123 | 123 | 1/1/2023 | |
| 2 | 456 | 123 | 1/2/2023 | |
| 3 | 789 | 123 | 1/3/2023 | |
| 4 | 456 | 1/1/2023 | ||
| 5 | 456 | 1/2/2023 | ||
| 6 | 456 | 1/3/2023 | ||
| 7 | 789 | 1/1/2023 | ||
| 8 | 789 | 1/2/2023 | ||
| 9 | 789 | 1/3/2023 | ||
| 10 | … | … |
1 Reply
CatherineMadden Try the following formula-
=MAP(A442:INDEX(A442:A50000,COUNTA(A442:A50000)),LAMBDA(x,INDIRECT("A"&ROW(x))))
