rows to column.xlsxHi,
How can i autofill the numbers in the column C4 on sheet 2 using the data in the row B10 on sheet 1.
Have tried using the $ function but get some very strange results.
Thank you
Dead*
sry - added file now
rows to column.xlsxHi,
How can i autofill the numbers in the column C4 on sheet 2 using the data in the row B10 on sheet 1.
Have tried using the $ function but get some very strange results.
Thank you
Dead*
sry - added file now
Last edited by dead*; 11-08-2015 at 02:00 PM.
Please post a small sample file showing expected results.
Can such a formula approach?Formula:Please Login or Register to view this content.
Sorry - i forgot
uploaded it now
Enter formula in C4 and copy down
Formula:Please Login or Register to view this content.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks