Hi everyone,
let's say I have 2 columns, A&B, A-containing just numbers and B-containing numbers,"Yes" and "No" which I want to update permanently. Is there any way to crate in another 2 columns, C&D which will update automatically only if in B i have a number(but without living spaces between rows). I'll give an example:
A B C D
10 Yes 20 18000
20 18000 40 25000
30 No
40 25000
50 No
And if I want to add now in A&B, C&D to update automatically only if in B I have a number:
A B C D
10 Yes 20 18000
20 18000 40 25000
30 No 60 22000
40 25000
50 No
60 22000
I already tried: =IFERROR(INDEX($B$1:$B$10,SMALL(IF(ISNUMBER($B$1:$B$10),ROW($B$1:$B$10)),ROWS(D$1:D1))-ROW($B$1)+1),"") but is making the file to heavy. Is there any simple solution without using macros?
Thanks ExcelMasters
Bookmarks