Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Robertislearning

    Excel: Consolidating multiple lines (Subtotaled)

    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...
  2. Robertislearning

    Average Subtotals (not including hidden rows)

    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...
  3. Robertislearning

    Excel: Formula to count rows

    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...
  4. Robertislearning

    How to count rows that have same value in Excel

    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...
  5. Robertislearning

    Lost Macros. Can't build new ones!

    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...
  6. Robertislearning

    Macro / formatting

    How do I create a Macro to go through a report similar to the one below that will highlight any row where the "Response time" exceeds 3 minutes? I don't want to use Conditional formatting as it limits me to 3 conditions. Receive Customer Response time 10:00 INR...
  7. Robertislearning

    Excel: Macro or Conditional formatting?

    Hello everyone, I pull a daily report that is similar to this: Receive Customer Response time 10:00 INR 5.0 10:15 INR 6.5 10:30 Cust 3.0 10:45 Cust 3.5 11:00 SRV...
  8. Robertislearning

    Powerpoint: How to configure to start slideshow automatically

    Hello everyone, How do I configure a Power point presentation so that when someone double-clicks on it to open it, it automatically launches the slideshow? Thanks in advance!
  9. Robertislearning

    Macro/Conditional formatting? Which to use and how?

    Hello everyone! I run several large reports daily that looks similar to this: (this is a fictional report) Number First Last Position Years in league 88 Michael Irving WR 5 84 Jay Novachek TE 10 8 Troy Aikman QB 8 22 Emmitt Smith RB...

Part and Inventory Search

Back
Top