Doubt on how to select a table end row ( with condition)

Naseer

New Member
Joined
Sep 3, 2014
Messages
7
Hi guys,

Could anybody let me know what is the solution for below query.

question: the table is in following format

a0
a
b
c
d
e
f
g
h
i
j
k
l
m
a
124
145
b
214
124
c
124
145
d
125
xyz
12541
d9
mno

<tbody>
</tbody>

here 'a0' is blank cell & After 'mno' i'll be having three blank rows.

this table is for an item x, and after three blank row there is also another table y & it follows to about 30 tables.

Now, my question is how to select the table starting from a0(1st row, 1st col) to d9(last row last colum) in a excel formula.

Please help me, i'm trying from last 2 days on my own but unable to find :(

regards,
Naseer
 

Some videos you may like

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

Watch MrExcel Video

Forum statistics

Threads
1,108,911
Messages
5,525,593
Members
409,653
Latest member
rishir

This Week's Hot Topics

Top