Hi to all
I have a workbook with a column C in which
there are non-empty cells.
How can I report the same values in column Y up to the next in column C
Attache example.
max
Hi to all
I have a workbook with a column C in which
there are non-empty cells.
How can I report the same values in column Y up to the next in column C
Attache example.
max
TryFormula:Please Login or Register to view this content.
Or this
Enter in Y3 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
It is partly accurate.
Values must be reported as image
After you use this formula, copy the entire range in col Y and Paste Special, Values only over the the range.
I do not understand.
I tried the formulas in the attached sheet and they work.
I have to try it on another workbook where in the cells of the column there are some formulas with = IFERROR (CONCATENATE (INDEX (.........
and I think the fault lies with these formulas.
Can you supply the workbook where it's not working & point out where the errors are?
Hi All,
a blind attempt: maybe formulae in column C are creating some problem, if they mark the cells with "".
=LOOKUP(2,1/(C$3:C3<>""),C$3:C3)
Regards
Last edited by canapone; 12-22-2018 at 02:57 PM.
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
Grazie della risposta canapone ma il problema è sempre che nelle celle c'è una formula
=SE.ERRORE(CONCATENA(INDICE(........
penso la colpa sian di questa.
----------------------------------------------------------------------------------------------
Thanks for the answer canapone but the probleam is always that in the cells there is a formula
=IFERROR(CONCATENATE(INDEX(.........
I think it's the fault of this.
Grazie della risposta canapone ma il problema è sempre che nelle celle c'è una formula
=SE.ERRORE(CONCATENA(INDICE(........
penso la colpa sia di questa.
----------------------------------------------------------------------------------------------
Thanks for the answer canapone but the probleam is always that in the cells there is a formula
=IFERROR(CONCATENATE(INDEX(.........
I think it's the fault of this.
Any chance of an updated file?
Hi fluff13 your formula is in foglio1 column Y
Thanks for the file.
Your formula is inserting a space into the "blank" cells
tryFormula:Please Login or Register to view this content.
I forgot to include a formula in the Foglio1 column K, now the formula does not work exactly.
I attach the workbook
In what way isn't it working, it looks fine to me.
image 1 Foglio2 cells empty
image 2 Foglio1 stop data
TryFormula:Please Login or Register to view this content.
Hi fluff13 now it works well.
Greetings and many thanks.
max
You're welcome
Hi,
I prefer Fluff13's approach
Anyway formula needed a blank space between quotes
=LOOKUP(2,1/(C$3:C3<>" "),C$3:C3)
Regards
Last edited by canapone; 12-23-2018 at 05:27 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks