Hi guys,,,
if I want to pass columns when filling cells, what's the formula for doing it?
for example I want to enter data in A1, A2, A3 (rows) or A1, B1, C1 (column) while the linked cell is D1, G1, J1
Thank you guys.....
regards
Hi guys,,,
if I want to pass columns when filling cells, what's the formula for doing it?
for example I want to enter data in A1, A2, A3 (rows) or A1, B1, C1 (column) while the linked cell is D1, G1, J1
Thank you guys.....
regards
Last edited by ASRAJO; 04-06-2020 at 11:30 PM.
at D1
=IF(MOD((COLUMN(A:A)+2),3)=0,INDEX($A1:$C1,D8),"")
copy from D1 To G1
what I mean is I want to use fillings with drag filling which is different from the lookup concept.
a simple example is like in the picture
btw thanks for the answer ghozi
screenshot => "drive.google.com/open?id=1q6MMkKFdwRrxvTGBFHSTSL9u_sKGNzhG"
Or better still following the yellow banner at the top of this page and giving us the data and the expected solution
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks