[sheet

  1. S

    Efficient ways to copy row based on condition

    I have data stored on main sheet [Sheet1]. There are 4 other sheets on the spreadsheet. [Sheet 2] [Sheet 3] [Sheet 4] [Sheet 5] I would like to copy the header (row 1) and data to copy to Sheet 2 from Sheet 1 if Sheet 1 column AA = 1; to Sheet 3 if Sheet 1 AB = 1, to Sheet 3 if Sheet 1 AC = 1...
  2. K

    Date Lookup

    Hello, [Sheet 1] as two columns. Column A [ID] and Column TIME [Sheet 2] as two columns. Column A [ID] and Column TIME [Sheet 2] holds all historical date for every ID and every occurrence in time that the ID performed a specific action. 1. What I am trying to create in [Sheet...
  3. K

    Reference look up with Date Associations

    Hello, On [Sheet 1] I have a listing of certain Customers, Customer IDs, and Times within my population. On [Sheet 2] I have a complete listing of all the Customer IDs and an Event Time. [Sheet 1] <tbody> Customer Customer ID Time (TIMESTAMP) Looking to see if a Event Time occurred...
  4. K

    Determine if Value is found within range of two other values

    Hello, [Sheet 1] <tbody> Type Number Item Is this number within Range? Red 12354 Apple N Red 6549866 Orange N Green 13216 Apple Y Blue 894 Banana Y </tbody> [Sheet 2] <tbody> Start End 123 129 880 990 13200 13300 8979 8980 </tbody> What I am...

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