Tech Support
Local Repair
Reviews & Ratings

Join | Answer Questions | Sign In

Help me with
Search
Home | Business and Productivity Software | For March in date col...
Business and Productivity Software
Problem for Microsoft Business and Productivity Software
Generic problem for all Microsoft Business and Pro...

For March in date column A2:A500 how man...




By pmichael674 on Apr 22, 2009

" "
For a particular month in a column of dates how many entries made in corresponding rows in another column? - P. Michael
Comments:

Apr 23, 2009

- I do appreciate your suggestion. I did some coding with VB. Now I am not using it due to corcumstances. May I have a solution in MS Excel.
Thanks for your concern.
-P. Michael
Ads by Google

Solution #1

posted on Apr 23, 2009
Not Rated)

fblock
fblock

Rank: Guru 
Rating: 87%, 105 votes
With VBA, you can write code to "loop" through that range of cells (A2:A500) and keep a count when the date is in March. With each iteration of your loop, test the value in the cell. Do the same for the other column. If this is not clear or I've misunderstood, please post back and we'll work on it more...
Comments:

Apr 23, 2009

- Sorry - but not sure of a way outside of custom coding for your need.
Was this helpful?
Yes
No

This Problem Also Relates To: Microsoft Office 2003 Basic Edition English (s55-00066) for PC Microsoft Office Standard 2007: Windows Microsoft Works 8.0 for PC Microsoft PowerPoint 2003 for PC Microsoft Works Suite 2005 for PC Microsoft Access 2000 (077-01277) for PC Microsoft Access 2003 for PC

Popular Solutions for Business and Productivity


Office Professional 2007 Full Version for PC
Microsoft Office Professional 2007 Full Version for PC
Need a prod key for home and student 2007
I just bought a new laptop vista already has home and student 2007 on it and it keeps...
1 Solution

Office Home and Student 2007 Spanish Version: Windows
Microsoft Office Home and Student 2007 Spanish Version:...
wrong code entered. I have an unused one...
I bought my wife a new laptop and it had a trial version of the office student...
1 Solution

Office Standard for PC
Microsoft Office Standard for PC
I accidently deleted microsoft office
I accidently deleted some parts of microsoft office from the C drive (not from...
5 Solutions

Office Word 2007 Upgrade: Windows
Microsoft Office Word 2007 Upgrade: Windows
product key
product key
2 Solutions

Excel for PC
Microsoft Excel for PC
Excel formula problem, Auto increment...
I'm trying to fix a spreadsheet that I have, it used to work like this: In one cell...
2 Solutions

Questions and Unsolved Problems for Business and Productivity


MPS Multimedia King Solomon's Lost Mines - 1,001 Treasures Full Version for PC (LGKISOMINJ)
MPS Multimedia King Solomon's Lost Mines - 1,001 Treasures

got new orange lg phone for xmas...

Answer
got new orange lg phone for xmas followed instructoins put sim in about six hours ago bet no message... (More)

Encore The Print Shop 23 Deluxe Full Version for PC
Encore The Print Shop 23 Deluxe Full Version for PC

I create personalized Calendars. I...

Answer
I create personalized Calendars. I have found that there is a problem with August. It moves dated... (More)

Handmark Software MobileLists (950142) for PC, Mac
Handmark Software MobileLists (950142) for PC, Mac

My biggest problem is getting...

Answer
My biggest problem is getting Handmark's so-called support to reply to me.

Business and Productivity Software
Business and Productivity Software

chartnexus username pass ward not...

Answer
hello sir, i am install the chartnexus software. but my username passward not received in my mail.... (More)


Didn't find what you were looking for?

Describe your Business and Productivity... problem:

Select a Category:





Ads by Google



Ask our Experts

Ask

 

Solve Your Problem Now!
Chat Live with an Expert
Chat Now
Top Business and... Experts
ikkenom
Rank:
Wiz
Computer Software
Expert

Rating:
79%, 863 votes


smb_146
Rank:
Guru
Computer Software
Expert

Rating:
98%, 370 votes


cameleon_one
Rank:
Wiz
Computer Software
Expert

Rating:
82%, 77 votes


Find more Business and... Experts
Top Computer & Laptop Repairmen
in , PA
Zkarlo.com
(952) 890-7770
Zkarlo.com provides discount and used laptop parts...
Zkarlo.com

A+ Rated Oceanside...
(877) 934-6198
Send your laptop to us and we will diagnose the...
A+ Rated Oceanside Computer Sales & Service, LLC

See More
Get Listed!

       
Solve Your Problem Now!
Chat Live with an Expert
Chat Now

Insert Link
Insert Image
Insert You-Tube clip
Insert List
Insert List
Spell Check

What is this?



Select