old version of excel

[dabielcrbyton]

a1	b1
2	2
4	4
4	4
	5
5	7
	8
7
8

i have an old version of excel
something like 10 year ago

i have array of number from a3:a10
please i need function begin in b3
that remove the empty cell in column a
like you can see in column b


thank you very very much

 

[Peter_SSs]

See if this works for your version.

21 08 22.xlsm
	A	B
1
2
3	2	2
4	4	4
5	4	4
6		5
7	5	7
8		8
9	7
10	8
Sheet2 (3)

Cell Formulas
Range	Formula
B3:B10	B3	=IFERROR(INDEX(A$3:A$10,AGGREGATE(15,6,(ROW(A$3:A$10)-ROW(A$3)+1)/(A$3:A$10<>""),ROWS(B$3:B3))),"")

 

[dabielcrbyton]

the b3 when i put the function
stay blank
i don't know whet the problem

can you help me with this


i have :

Excel 2010​

​

​

 

[Marcelo Branco]

Well, it's not identical but similar to...

i need function for combine table

a1 b1 c1 d1 2 2 2 2 4 2 4 3 4 4 8 4 8 8 hi everyone i have the excel : i have a problem i sit down to finger it out but i cannot succeed of solving it i have numbers in a3:a7 and numbers in b3:b6 i need function for d3:d7 (...

www.mrexcel.com

M.

 

[Peter_SSs]

the b3 when i put the function
stay blank
i don't know whet the problem

Try this

1. Start a fresh blank worksheet
2. Go to my mini-sheet in post #2 above and click this button:
   
   
   
   
3. Select cell A1 in your blank worksheet and Paste.

What happens?