a1a100

  1. L

    selecting cells short cut

    Hi I want to select let say 100 cells A1:A100. I can do that using mouse but I wonder of I can select A1 and then go to A100 and they are all selected. I select A1 and I can go to A100 using F5 and type A100 but that would jump to A100 without highlighting the range A1:A100. Thank you.
  2. M

    How to create a range from a cell value and repeat time in another cell ?

    Right now I have a data A1:A100 each cell is 500 So my range called RangeA is A1:A100 Can I do without need to have this list in this 100 rows Now I key in, B1=500, C1=100 How can I create RangeA based on these two cell values ?
  3. N

    Excel Formulas

    Hello folks, good day. Please could anyone help me with this. I want to write a formula that will return a "YES" or "NO" if a value in a range of cells is a match with a value in another range of cells in another worksheet in the same workbook. That is, for example if a value in Sheet 1 A1:A100...
  4. countryfan_nt

    Power Pivot: row items chosen from range.

    Hello friends, hope all is well! Please help with code; I am getting: VBA Runtime Error 1004 “Application-defined or Object-defined error”. I am trying to choose / filter the row field, from the range A1:A100 of sheet2. so whatever is in range A1:A100 will impact and chosen to filter the...
  5. A

    Using concatenate function to combine array of numbers

    How can i concatenate an array of numbers say A1:A100? I'm getting error as #value ! When i use =concatenate (A1:A100). As I'm not using a latest version of Office, i cannot use textjoin function.
  6. L

    when to apply subtotal() after the filter or before

    Hi Let say I have A1:A100 column. I want to find the subtotal. I filtered column A and now I have 20 cells. Should use subtotal before filtering the column? I mean to select A1:A100 or after filtering the column and then select the 20 cells left? I tired it both, sometime both work but some...
  7. P

    Number lookup match

    I am trying to look in A1:A100 for the number that is the closest to D1 and then return the value from the corresponding cell from B1:B100. If there are 2 numbers in A1:A100 that are the closest to D1 then return the corresponding number from B1:B100 from the first one it comes to. Hope that...
  8. A

    Finding Duplicates

    How can I highlight duplicate cells in a column if when checked against another column I have numbers in A1:A100, and numbers in C1:C2500, how can I highlight the numbers in column "C" if they appear in column "A"?

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