$a$1

  1. G

    Indirect function

    Hi, I have a formula as follows: INDIRECT(" ' "&C2&" '!$A$1:$B$30") C2 holds sheet name to which I want the VLOOKUP in which this INDIRECT function is embedded to use. Can someone please tell me how to amend the above formula so that the $A$1 and $B$30 can be referenced from adjacent...
  2. T

    Help with understanding a remove duplicate macro

    Hello, I'm new to VBA and had searched through the forums and found the following macro than can be used to delete duplicate rows where the range is dynamic. would you explain to me how does this macro work? what is the meaning of this in particular (strRange = "$A$1:" &...
  3. L

    relative vs absolute (mix)

    Hi I want an example when mixed cell reference is needed. for example A$1 or $A1. in all examples I am seeing so far, using $A$1 instead of A$1 or $A1 can fix the issue as well. then I am wondering why need the mix when $A$1 can be used, the link below is one of the examples i have seen so far...
  4. J

    Find Index Value of 2nd, 3rd, ect. Mentioned Value

    Hello - I have data in columns A1:PQ1 and I need to find the position of several different letter/number combinations in the array. For example, when I use: =MATCH("XVALS"&"*",$A$1:$PQ$1,0) it returns 33 (corresponding to AG1). For the next search I can change $A$1 to $AE$1, but this...

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