I have a Generic Inquiry (GI) that returns a dynamic table for my monthly transactions. The bolded row 1 contains the GI formulas. The green rows are the
dynamic output. So when you click into them they show the same formula as in row 1.
I want to automatically extract data from the description field and put it into columns N and O.
The problem is that if I put my formula in cell N2 it returns a blank and N3 returns what should be populated in N2. I end up with a blank cell in N2 at the top and an
extra cell at the bottom.
To fix it I need to put the formula as shown in cell P1 in N1, rather than N2, then everything matches.
But it means I cant put a header label in N1 and I want to , so as to use for a pivot table.
Is there any amendment I can make to the formula in p1- so I can paste it into cell N2 and it will return the correct data? I have a feeling
it’s a count formula but I am stumped.
I am very new to all this and would appreciate some ideas.
Thank you.
Please have a look at the attached file and see if it does what you need.
Thank you Riny. No. I renamed the header row of the table as headers but i cannot put anything else in the N1 or O1 cells as that contains my formula.
Hi Julie,
Try this in cell N2:
=MID(INDEX(B1#,SEQUENCE(COUNTA(INDEX(B1#,,1))-1,,2),9),18,6)
Mynda
Thnak you so much Mynda, this worked. Which course covers this learning? Really appreciate it.
Great!
I cover these functions in the Excel Expert course or the Advanced Formulas course, which is an extract of the Excel Expert course. I don't cover that specific scenario though
Mynda
