Search threads

This Week's Hot Topics

• two formulas needed

  • Started by SplatP1
  • Mar 27, 2020
  • 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...
• code not looping.

  • Started by orsm6
  • Tuesday at 12:24 AM
  • Replies: 30

  hi all - i thought this code would loop through the range and put a formula in every box ... but it doesn't. how can it be changed to make it...
• Help Excel formula eliminate duplicate values and keep only 2 identical rows.

  • Started by Nguyen Anh Dung
  • Mar 28, 2020
  • 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
  • Mar 28, 2020
  • 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...
• How do I select the number of rows until i reach a certain value

  • Started by asddsaasddas
  • Mar 24, 2020
  • Replies: 22

  For instance, I have column A populated with different random words. So for example at row 6, I have a "#N/A" instead of a random word. I want to...