8/1/2019

  1. A

    Tag duplicate rows based on a specific criteria

    Hi Excel Guru's Need help please, I know what my logic should be, I know what my result should be, but I am unable to build any formula to show the result I need. Below is the data set up and three different scenarios. The column named [Primary File Number line TAG] is where I would like to...
  2. R

    VLOOKUP a date+time with only a date

    Can I Vlookup a date+time if I only have the time? For example, I have the Scheduled Time only in Table B. I want to Vlookup the Date+Time from Table A. <tbody> Table A: Reference Table Table B: Final Table Scheduled Date+Time Actual+Time Scheduled Time Actual Date+Time (VLOOKUP)...
  3. B

    Pivot table Question

    I have a spreadsheet with a column of names and column of dates. The column of names have duplicate names for same dates. I need to count how many names were on a certain date but my pivot table only sums the name column. I there a way to count the individual names that appear for each date...

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