By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,708 Members | 2,080 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,708 IT Pros & Developers. It's quick & easy.

Excel VBA display the most frequent value in a range that changes based on blank row

P: 82
Hi, Excel VBA question. I have a spreadsheet that shows employee types per company. Each company has a blank row after the last employee. I need to write some code that will look at column H (the employee type column) and insert the most shown employee type for that company. Does anyone have any idea on how I can do this? Thanks in advance.
Nov 15 '13 #1
Share this Question
Share on Google+
3 Replies


ADezii
Expert 5K+
P: 8,652
In this case, inserting a graphic of the Spreadsheet, or attaching it with some sample data would be most helpful.
Nov 16 '13 #2

P: 82
A sample had been given the other day.
Nov 18 '13 #3

P: 82
Ooppp..guess i didn't post the sample. Here it is.

Company# CoName AgesServed Web Specialty Second Specialty TaxID JobTitle JOBID

793 AFC Adults and Children TRUE 2 Temp 08
793 AFC Adults and Children TRUE 2 Clerk 50
793 AFC Adults and Children TRUE 2 Clerk 50
793 AFC Adults and Children TRUE 2 Clerk 50
793 AFC Adults and Children TRUE 2 Clerk 50
793 AFC Adults and Children TRUE 2 Janiter 48
793 AFC Adults and Children TRUE 2 Manager 99

539 OGAssoc Adults Only TRUE 55 Clerk 50
539 OGAssoc Adults Only TRUE 55 Trainee 16
539 OGAssoc Adults Only TRUE 55 Trainee 16
539 OGAssoc Adults Only TRUE 55 Trainee 16
Nov 18 '13 #4

Post your reply

Sign in to post your reply or Sign up for a free account.