adress

  1. M

    Based on location return a highest and least values and absolute, relative addresses of cells.

    Hi, I required a formula help for return a values based on lookup location Highest and least values of amount and return a cell addresses of that absolute and relatives in column F, Cells F4 to F9. Sample enclosed a for the reference. Thanks, ABCDEF123ItemsAmountLocationLookup...
  2. F

    Show first item in data validation dropdown

    Hello, I did use formula right in the cell before. But If I remove other info the formula will be removed, so I decided to use data validation lists instead. I'm having =INDEX(OFFSET(BusinessNameStart;MATCH(D3;BusinessNameList;0)-1;2;COUNTIF(BusinessNameList;D3);1);1) So, this one will find...
  3. M

    sending multiple email via lotus notes to specific address

    hello , I have a xlsm file that is extracting some data from SAP system about some articles , the ideea is that when we have some changes for part of the articles we need to send a information emai via lotus notes with te changes , now the problem that we have is that not all the articles are...
  4. S

    Plot graph using cell adress instead of cell values

    Hello I have to hundreds of columns and I have to create a graph for each one of them, so I created the following macro to save me some time: Sub PlotC() ' ' Macro PlotC ' a = Range(ActiveCell.Offset(1, 0), AddressveCell.Offset(0, 0)) b = Range(ActiveCell.Offset(2, 0)...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top