Search threads

This Week's Hot Topics

• help please

  • Started by formratings
  • Mar 24, 2020
  • Replies: 41

  SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
• two formulas needed

  • Started by SplatP1
  • Friday at 5:50 PM
  • Replies: 39

  Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
• Dynamic Counts

  • Started by ellison
  • Mar 23, 2020
  • Replies: 32

  Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
• Help Excel formula eliminate duplicate values and keep only 2 identical rows.

  • Started by Nguyen Anh Dung
  • Saturday at 2:29 AM
  • Replies: 27

  as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
• Macro Compile Error Sub or Function not defined

  • Started by paulfitz54
  • Mar 25, 2020
  • Replies: 27

  Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
• Last row combined with Current Region VBA

  • Started by Tigerexcel
  • Saturday at 5:00 AM
  • Replies: 24

  I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...