Results for "formula look value"

Hi,

I'm not exactly sure what you're looking for, but I'll answer assuming you want to remove duplicate rows.

If you don't need a formula, you can do Data -> Remove Duplicates:

If you have the possibility to use a recent version of Excel (or Google Sheets), this can be done easily with the UNIQUE function:

Dear Colleague,

Please could you help me to resolve this issue as per the file attached

Hi MAK TZ,

Since your version of Excel is "The latest," I assume it's 365... Here's a formula

=IF(D2<>"";XLOOKUP(D2;$A$1:$A$34;B1:B34;"Not found";0;1);"")

to put in cell E2 and drag down from E2 to E7.

That should do the trick!

DanD

Hello and welcome to the forum,

Which version of Excel are you using? 2016/2021/365... ?

Then your table is very unclear to me, how are we supposed to know which shops are under location 10PK738?

Are you looking for a simple sum by shop name, aka https://excel-pratique.com/en/functions/sumif, or a more complex analysis?

please

look into my file

need formula on e2 drag down to find stocks by location from data column a and b

See my file manually done

Hello,

Your workbook does not seem to be in line wih your initial question ...

Indeed, there is no macro ... and could not find a formula using Indirect() ....

Hello!

Sorry for replying late! Please find an example file attached here. I hope it is usable, else I will try to modify it.

Thanks a lot in advance!

Hello Lucie,

To be on the safe side, why don't you attach your Excel file ....

Cheers

Hi,

I am trying to run a macro replacing a part of a formula using find-replace:

Find: AND(

Replace: AND(INDIRECT(“AL”&ROW())="1");

(within the macro of course quotation marks are added)

When recording the macro this works perfectly fine, which is unfortunately not the case when I want to apply the macro in another file.

Thanks a lot in advance if you have any advice on this!

Lucie