Results for "macro find replace formula"

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

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

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 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 ! Lisa Nguyen,

Here, your Excel File is back, with automatic conversion.

If you agree, you can display the corresponding color with your VBA Module3. Sub RGB_TO_HEX_COLOR()

See my Note in Sheet1.

Breaking News,

Excel File Version2 is coming Now.

Best Regards.

Re,

A Power Query proposal to study.

Regards.

Hello,

Understand you cannot attach your workbook ... for confidential reasons ...

However, the one thing you could do is insert the code you have created ...

It might be that ... just by looking at your macro ... a solution might pop up ....

Hello and welcome,

try this, select the data and execute this macro.

Sub createcolumnchartwithselection()

    Set ch = ActiveSheet.Shapes.AddChart2(366, xlColumnClustered)
    ActiveSheet.ChartObjects(ch.Name).Activate
    ActiveChart.ChartArea.Select
    ActiveChart.ChartStyle = 201
End Sub

Hi there, i am new to vb excel and i need help.

What would be the macro for making excel create time series chart if two columns are selected where the left column is dates and right column is data

Good evening Lisa,

I propose you here a fully automated version of the macro, meaning that :

When you modify the hexa color, it will both change the RGB values accordingly and change the color of the colored cell automatically too.

When you modify one of the RGB value, it will both change the Hexadecimal value accordingly and change the color of the colored cell automatically too.

No need for any button to apply the tranformations.

Wow really thanks for what you did! I saw the message you left on the excel file!

I will now try to analyze and understand what you have written in the code.

Thank you again and if you manage to switch from RGB to HEX it would be amazing !

Hello,

For my internship, I have to create an excel macro to convert a color value in hexa code to rgb and vice versa.

I have already done a lot of research on google and in general I find excel formulas (use of boxes in the formulas to convert) instead of a VBA code. In addition, it takes usually 2 tables, one from hex to rgb and another from rgb to hex.

But I'm looking for an automatic conversion, that is to say to make a modification of the hex value, the rgb value is updated and vice versa, all in the same table.

All these data are organized by columns and you need a third one to display the corresponding color.

For the moment I have fulfilled my specifications but it is not optimal, I have indeed two tables. I call for your help today to help me to optimize my code.

Tell me if it's not clear haha, I did the best I could. I put in attachment the excel file as is.

Thanks in advance !