Hi Everyone,
I have in a sheet 1 a list of colours.
I would like to put a formula in sheet 2 to give me all the colours with results. (sheet 2 - "P9 to P19") without space lines as is in sheet 1.
thanks for your help,
Regards,
Hi Everyone,
I have in a sheet 1 a list of colours.
I would like to put a formula in sheet 2 to give me all the colours with results. (sheet 2 - "P9 to P19") without space lines as is in sheet 1.
thanks for your help,
Regards,
with Power Query
CÔR No PRICE FINAL PRICE WHITE 2 10.00 20.00GREEN 3 25.00 75.00PURPLE 5 27.00 135.00
Please Login or Register to view this content.
Thanks Sandy but i don't now work with power Query
you are welcome
pity , this is very useful thing
have a nice day
P9
copy down and acrossPlease Login or Register to view this content.
Office 2019
P9
Please Login or Register to view this content.
I wrote =SE.ERRO(ÍNDICE($1:$100;AGREGAR(15;6;1/((MATRIZ.MULT(--(GERAL!$B$11:$J$38<>"");{1;1;1;1})=4))*LIN(GERAL!B$11:$K$35);LINS(GERAL!$B$11:B11));COL(GERAL!B11));"") and don't give me any result ????
Now I understand the example I give you is not exactly what i have in the original one. I try change the formula but not give nothing !
I send you again, this time the original one with 2 sheet's "GERAL" - Where I write the values and "FACTURA" where i would like give me in "F", "K" and "L" the values fill in "GERAL", only if they are not empty.
Can you help me again ?? many thanks
Last edited by Vinhas; 01-12-2023 at 10:07 AM.
I think your data has dynamic columns, you must modifiy the formula according to your data.
Maybe, you can upload your final workbook.
I send you again, this time the original one with 2 sheet's "GERAL" - Where I write the values and "FACTURA" where i would like give me in "F", "K" and "L" the values fill in "GERAL", only if they are not empty.
Can you help me again ?? many thanks
Try this,
FACTURA!F22
Merge cells is not recommended in formula.Please Login or Register to view this content.
Last edited by windknife; 01-13-2023 at 07:19 AM.
thanks for your help but it doesn't work as you see in attchament i send with your formula. Is possible you try to see If i'm doing samething wrong in the attchament ??
Note: I try to put your formula in "B22" (????) and in "F22" but doesn't work!
Thanks
i made a typo, it should be F22. see attachment
Thanks! Is done !
But what changes I have to do in the formula to work in "FACTURA" columnns "K" and "L" ???
Change last GERAL!B11 to GERAL!F11 in cell K22.
Change last GERAL!B11 to GERAL!G11 in cell L22.
K22
L22Please Login or Register to view this content.
Please Login or Register to view this content.
Doesn't work ???
I send you in atchament with the formula as you give me.
Please, see attachment. remove "@" symbol.
Many thanks !! Done !!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks