Hi, I need some help with filtering and selecting specific cells with multiple criteria.
I have a table with a list of fruits and their expiry date.
I have tried using VBA to auto-filter the fruit data that are expiring in current month. (xlFilterThisMonth).
However, I only want to select data...
Hello,
How do you write a macro that has an entire range of D3:AD29 equal to the following formula =sum(countifs(range,criteria,range2,criteria2),countifs(range,criteria,range2,criteria2))?? THANK YOU!!!
Not sure if this is a duplicate question but couldn't seem to find it anywhere.
I have the following sample data:
<tbody>
A
B
C
D
E
F
G
H
I
1
EMPLID
NAME
Dept
LOC
JOB TITLE
EE STS
EFFDT
HIST EFFDT
HIST EE STS
2
123
Doo, Scooby
564
564C
Driver
L
4/28/2018
3/20/2017
L
3
123
Doo, Scooby...
Hi All,
If this was previously answered, please direct me to that link so I dont have to have you repeat yourselves haha. I honestly dont know what keywords to be searching for. Otherwise, if you can help it would be really appreciated.
My company write a bunch of orders (A) which have one or...
Hi,
I am trying to rank a list of orders withing a container based on their shipment date. The difficulty is that within each container there can be multiople orders with the same shipment date. I can use SUMPRODUCT to rank multiple criteria and get the order within each container. 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.