Results for "copying value different column complex formula"

Hi MatthieuB08,

test this file if it's you're wondering.

Good evening.

Dear all,

I wondering if there is a formula that could help me to obtain the following output (in orange) table :

Thanks in advance

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

Re,

A Power Query proposal to study.

Regards.

I see. The website site have updated it column to "Reference". Before it was "Blank" no wording under the column. Thanks again. Greatly appreciated.

Hello,

I reviewed the PMI request.

Is this the expected result?

"Hello,

What is the object of the "Added prefix" steps?

Regards."

Is to change the "Reference" column to "DATE" format

Hello,

What is the object of the "Added prefix" steps?

Regards.

Hello Everyone or Anyone.

Can You help me out with something.

I am trying to refresh my data links.

But I am getting an error that says: "expression.error the column of the table wasn't found"

How can I fix this?

Please if you are welling, please view.

Thanks in advance....

Jean-Eric

I love you, I love you, I love you...

Thank very much.

Much thanks to you and your patience, working with me especially with my English language.

You should become my excel teacher.

Greatly appreciated

Thank you again. God Bless You.

Hello Jean-Eric,

Thank you for your swift response.

Please view the sample file below.

Please note: the raw data is on cell "A1" and

The extracted data example is on cell "N" and cell "O"

There are many excel workbook I need to extract data.

How can I create a universal code to extract each one.

Thanks in advance. Greatly appreciated.

Hello,

Please attach a small file at your request.

Regards

Hello Fans.

Currently I have Many Raw Data as an example below to section out.

What's beautiful, all the following data are similar:

Here is an example in row "1", in column "A" only :

0: {c: 9, close: 9, yield: null, referenceDate: null, date: "1997-03-01T00:00:00", …}

In this Case: How can I Keep the values of The following:

9 1997-03-01

I have multiple data similar like above. The comparison with the others are, values and dates.

What is the effective way to get the data?

Or what code can I use? How do you want me to proceed?

Thanks in advance

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