MrExcel Message Board

This Week's Hot Topics

• Stuck again. extract data from cell between : &; mulitiple instances

  • Started by Ozzy_Bruce
  • Oct 16, 2020
  • Replies: 49

  Hi guys, this has me stumped. I am copying data from an online database that I am wanting to add to my own db, I can copy from the info from the...
• How to get VBA to return a count of selected rows in a filtered range for processing.

  • Started by Sej
  • Saturday at 12:56 AM
  • Replies: 30

  Hi, Forgive me if I use non-programming terms - I am a self taught coder at a very basic level. And I just learn from forums such as this. But...
• need only data

  • Started by sksanjeev786
  • Monday at 4:00 AM
  • Replies: 31

  Hi Team, I have data in various formate. can I get any formula to find only data. There will be % space on random data but I need only data i.e...
• Need more than COUNTIF function, I think..

  • Started by sunstarer
  • Oct 16, 2020
  • Replies: 27

  With some of your help I built a spreadsheet that tallies wins in a game, that populates a cell with a win count. Works great. See below...
• Pushing an image to the following page if it is over the page break

  • Started by dpaton05
  • Oct 15, 2020
  • Replies: 41

  I have a procedure that pastes in a signature from another sheet, just below the bottom of a quote. Is there a way to push it to the next page if...
• Timesheet formula not working when calculation spans 2 days

  • Started by Bonnie Janes
  • Oct 13, 2020
  • Replies: 26

  Hi, I have a formula that works until the times involved span 2 days: Formula is "=TEXT((EE24-DT24)-(FA24-EP24)-(FW24-FL24),"h:mm")" it first...