1/3/2018

  1. S

    Average if Formula Help

    Hello. how can i add weekday to the formula below. right now the formula im using is giving me the average interval, i need it to say per weekday per interval . im trying to get the average for all mondays in the year at 8:30 am. {=AVERAGE(IF(($A$2:$B$18927)=$E2,$C$2:$C$18927))} a...
  2. D

    Add blank row in data set IF no data exists

    Hey guys, Sorry, pretty new to this stuff so hopefully i can accurately describe what im trying to achieve. I need to have 3 rows for each DAY/NIGHT to filter through to more functions. At times, i only have 1 value for this shift so will need to insert 2 new rows to make things balance. I...
  3. T

    Excel VBA multiple criteria copy and paste

    Hi there, I am new to this forum I would very much appreciate it if you could help me on the following task. I have a spreadsheet of approximately 35,000 rows and I try to copy dates from columns B and C to columns D and F if they meet the following criteria:1. Date criteria: If a date falls...
  4. B

    stock card to excel

    good day, i'm trying to convert our family business stock card to excel but having difficulties, exactly i have no idea on what formula should i use to achieve this, here are a few details on our stock card <tbody> date inventory in inventory out Stocks on Hand 12/25/2017 44 44 12/26/2017...

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