hi,
i have data in sheet 1 as per below data, and need a formula to get the data clubbed with similar data and get the output as per sheet 2 in columns A,B & C as per data below
Sheet 1
<tbody>
A
B
C
41001
MAY-19
350
41001...
Hello Reader's,
Our financial year runs from Jan-19 to Dec-19. Currently we are in May-19 period therefore we have finalized actual sales data for the period Jan-19 to Apr-19 period.
I need help to construct a Quarter to date formula.
For example in below data: I need a formula that will...
Trying to find out how to get a SUMIF to work on the following information.
I have the following columns of data:
Col A Col B
Apr-19 $25
Apr-19 $50
Apr-19 $75
Apr-19 $25
Apr-19 $50
May-19 $100
I only want to SUMIF Anything that is Apr-19, so for the example above the...
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.