Hi,
Required a formula help to as per data available in working sheet, return a sum values in column C as based on task ID and Ledger by ignoring duplicates whatever available in column A and B (task ID and Ledger) in the summary sheet.
Expected results are available in summary sheet column E...
Hey Guys,
I'm stuck trying to prevent duplicate appointments being created when i run the following code to import excel dates to outlook.
Public Sub CreateOutlookMeetings()
Sheets("sheet1").Select
On Error GoTo Err_Execute
Dim olApp As Outlook.Application
Dim olAppt As...
Hi there,
I'm a complete newbie at VBA, only looked at my first code this week!
After searching many forums (thanks for your help everyone!) I have modified code to work somewhat.
My macro currently copies a template and renames it based on data on my "estimate" sheet, what I need help with...
Hi Guys, hope you can help me with a countif formula to count the days the running activity was done and ignore the amount of times it might have been done in the same day. The count for running days must equals 3 in the example table below.
<tbody>
Activity
Date
Total Running Days
...
I have Excel 2007, using a Table called sawmillTable
I am looking for the count of days the machine ran. There are multiple days because of breaking down dimensions, specie, etc. So I need to ignore duplicates in the [date] field, I think.
If someone could help get me started that would be...
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.