MrExcel Message Board

This Week's Hot Topics

• User form to query (up to) 8 worksheets

  • Started by Mel Smith
  • Saturday at 4:52 PM
  • Replies: 75

  I have a workbook containing 8 identical sets of data, all laid out with the same persons occupying the same row and the same data occupying the...
• Multiple IF Statements for a Range of Cells

  • Started by JubberB
  • Tuesday at 7:08 PM
  • Replies: 32

  Hey! I need to write a formula for multiple IF statements that return a result after searching a range of cells. Here's what I have so far: Data...
• Returning top 3 list with duplicates using INDEX, MATCH, IF, SMALL & TEXTJOIN

  • Started by Dlloyd15
  • Feb 20, 2020
  • Replies: 31

  Hi all, Firstly I'd just like to say I'm fairly new at using extensive functions in Excel, so if I've missed anything or am doing this the...
• Create .TXT Subsets based on existing Excel data using VBA Macro

  • Started by Rakesh99932
  • Tuesday at 1:55 AM
  • Replies: 29

  Hello Guys, I need to create Subsets for the data which I have, which is dynamic, using Excel VBA. I have data in the form of table, whose column...
• Sum first n cells

  • Started by raikks
  • Sunday at 1:21 AM
  • Replies: 25

  Hi - I need a formula that sums the first 3 cells of component1 that contains ``yes'' (result should be 88) Also - I need to sum the first 3 cells...
• Can you advise a different way of this code to work please

  • Started by ipbr21054
  • Tuesday at 6:11 AM
  • Replies: 25

  Morning, Please see working code shown below. I have a worksheet where i enter data and in column G, the word POSTED is shown & also RED. Once...