range of data

  1. A

    Excel to return a value in a column, if multiple criteria meets

    I tried to return a value in sheet1, column A (vertical), to sheet 2 (Horizontal format), if the "Process_Step" and "WO" is matched. As the data is huge and there're many columns, I do not know how to specifically to use the index and match or vlookup, to return the column A value (Date) if the...
    • Ann Ooi
    • Thread
    • excel & array formula index & match multiple criteria range of data
    • Replies: 22
    • Forum: Excel Questions
  2. CephasOz

    Determining worksheet data area

    There are a few standard ways to find the area containing data in a worksheet, but each has a problem. 1) Activesheet.Cells(1).CurrentRegion won't work correctly if there are blank rows or columns 2) Activesheet.Cells(Activesheet.Rows.Count, 1).End(xlUp).Row won't work correctly if there is...
    • CephasOz
    • Excel Article
    • data analysis last active cell of sheet range of data
    • Category: VBA and Macros
  3. J

    Transforming the Range of Data

    Hello, I have two fields with data each ranging from 0 to (potentially) the hundreds of thousands. What I need to accomplish is to re-scale column B so that it matches the range of column A. For example, if column A values were from 0-50,423 and column B values were from 0-78,534, I'd like to...

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