Iknewthisguy
Active Member
- Joined
- Jan 22, 2009
- Messages
- 274
Morning all,
I have a query that populates my spreadsheet with 15 properties (all with a specific name) and then floor plans underneath that. I am trying to select the last line with the floor plan name in front of it and pull that out. The problem is that floor plans repeat themselves amongst the properties. Ideally what I need to do is write a formula that will find a specific property name (i.e. Woodbridge) and then return the last line that says 1x1au under that (with the the 1x1au being the last occurrence in consecutive occurrences because it will most likely occur again later. My sample data looks kind of like this:
I realize this is a complicated question so any help that could be provided would be greatly appreciated.
Chris
I have a query that populates my spreadsheet with 15 properties (all with a specific name) and then floor plans underneath that. I am trying to select the last line with the floor plan name in front of it and pull that out. The problem is that floor plans repeat themselves amongst the properties. Ideally what I need to do is write a formula that will find a specific property name (i.e. Woodbridge) and then return the last line that says 1x1au under that (with the the 1x1au being the last occurrence in consecutive occurrences because it will most likely occur again later. My sample data looks kind of like this:
Code:
Woodbridge
0
0
1x1au
0
0
1x1au
0
1x1au
Corte Bella
0
1x1au
0
1x1bu
0
0
1x1bu
0
0
0
1x1buI realize this is a complicated question so any help that could be provided would be greatly appreciated.
Chris
