Recent content by Robertislearning

Thank you very much for your assistance!!!! You have helped tremendously. I apologize for the delay in responding, I've been tasked with a project that took priority over my normal duties (I'm sure you all can relate....) Again, Thank you very much!!!!!!

Hi John, The Subtotals are already there when the spreadsheet is sent to me. My 'to do' is to consolidate each section (like the Eat at Joe's section above). For example, in the sample given in my first post, I go through and highlight and sum cells E2 (value = 10) through E5 (value = 30). I...

Hi everyone! I have a weekly report of 1,000+ lines that is provided to me to "condense". The report looks as follows: A B C D E Prob# CustName Date Time Duration (minutes) 001 Eat at Joe's 12/01 10:00a 10 001 Eat at Joe's...

Gentlemen, Thank you very much for this valuable information. I sincerely appreciate it! Robert.

Hi all, I have the following sample spreadsheet. A B C 1 Apple 2 3 Apple 2 5 Orange 2 I am looking for a formulas that would give me the average and count of ONLY the VISIBLE rows. For example, I would expect an average of 2 and a count of 3. (Notice...

Thank you two very much for your time. It's working! I sincerely appreciate your efforts. Robert. (I thought there was a place for me to flag this as a very hepful tip. Perhaps stars or something. I'm unable to find a place to flag this post. Either way, thank you two very much!)

Hi SkipVought, Thank you very much for your suggestion. I believe that this will work. I've been playing with it and I believe I need only one more tip. What is the syntax for selecting individual cells? For example: In the sample below, how would I write the formula you suggested...

Hi! I have the following sample data in a spreadsheet: A B C Sue Yes Yes Yes Ann No No No Joe X X X Bob X X X Kay Yes Yes Yes I'm trying to figure out a formula that will give me the total number of people...

Hi! I currently have a 400+ line report similar to this: Jan Feb Mar Emp A X X X Emp B A X A Emp C X X X I'm looking for a formula that will count all rows that have an "X" all the way across (B2, C2 & D2). I was going...

Anne, Success!!!!! I went in to My Computer and set it to show hidden files but unfortunately it still did not find the personal.xls file. Then I decided to go back and do one final search and found the 'Advanced' search button. In there I also checked 'find hidden files' and wham! It found...

Anne, Thanks again for such a quick response! When I try to record a new macro, I get the following message: "Personal Macro Workbook in the Startup folder must stay open for recording." One interesting thing is that I CAN create a macro for an individual Workbook. Unfortunately...

Anne, Thank you so much for your prompt response to my post. I did a search for personal.xls and sure enough it was not found. I take it that this file is where all macros are stored. My question now is do I just place an empty notepad document in there and name it personal.xls? Also...

Team, For some reason I have lost all of the macros that I built and saved in my Personal Workbook. When I try to go back and rebuild a macro, I get the following message: "Personal Macro Workbook in the Startup folder must stay open for recording." Has anyone seen anything...

VBAjedi, Item #1 above worked perfectly! With Item #2, when I run the macro it just seems to hang. I get the hourglass, and the first few conditions work properly, but it seems as if when it gets to the first Value that I want to exclude it just hangs. This goes on for several minutes and I...

VBAjedi, Thank you so much for your input. I've spent the better part of this morning studying it. I was able to run the macro with your code and it worked. I do have two more questions as I begin to tailor the code to my actual report. 1) When it highlights a row, the entire row is...