Column "C" is populated with dates.
What 2 formulas will count instances where dates have been:
• Repeated.
• Not repeated.
mgs
I'm using Excel 2010
Column "C" is populated with dates.
What 2 formulas will count instances where dates have been:
• Repeated.
• Not repeated.
mgs
I'm using Excel 2010
For better help. upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
A B C D E 3Data Category Counts Definition 4 10 10 1<=10 5 11 20 411 to 20 6 12 30 021 to 30 7 14 40 031 to 40 8 18 50 241 to 50 9 44 60 151 to 60 10 49 70 361 to 70 11 56 80 071 to 80 12 61 90 281 to 90 13 66 100 191 to 100 14 70 1>100 15 83 16 84 17 93 18 101
D4=FREQUENCY(A4:A18,C4:C13)
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Here is my new attachment.
I want to insert the formulas into P4 and Q4
mgs
Last edited by mgs; 10-09-2015 at 01:00 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks