a25

  1. P

    Date Conditional Formula

    Hello! This formula is beating me... Cell A25 contains the date 11/7/2019 and Cell B25 contains the date 11/20/2019. I also have the following starting at H2 (H2 contains the date 11/7/2019): <tbody> 11/7/2019 11/21/2019 12/5/2019 12/19/2019 1/2/2020 1/16/2020 1/30/2020 2/13/2020...
  2. T

    Messagebox listing going down instead of across

    The code below lists the address of all cells in a pre-defined range whose value is zero. Dim Rng As Range With ws Set Rng = .Range(.Cells(1, 1), .Cells(1,1000)) End With Dim ZeroColl As Collection Set ZeroColl = New Collection Dim...
  3. J

    Changing part of formula/leaving other parts intact

    Hello I need to drag this formula down several cells however when I do itchanges the values by 1. =VLOOKUP(A25,$A1:$I20,5,FALSE) How do I keep the formula “$A1:I20,5,FALSE”intact but change A25 to be A26, A27, A28, etc.,? Thank you.
  4. T

    How much did X do Y and Z

    Hi, Let's say I have a list with orders with every row has seller ID and a product serial nr So it could be (the name and serial nr are different cells) John A23 John A23 Marcus A25 John A25 So in another sheet I have A23 A25 John 2 1 Marcus 0...

Some videos you may like

This Week's Hot Topics

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
Top