shortuct

This Week's Hot Topics

• Index and Match between Two Dates

  • Started by matthewlouis
  • Jul 3, 2020
  • Replies: 38

  Hey EXCEL experts, I need a formula for an index and match that looks for a number that is below another cell number. Attached is an image with...
• Tax calculation... IF/AND/OR?

  • Started by BrutalLogiC
  • Jul 1, 2020
  • Replies: 27

  Hello board, I'm struggling with a formula to calculate the tax contribution where there are a number of different salary bandings and rates. I've...
• Largest Letter

  • Started by suechetty
  • Jul 4, 2020
  • Replies: 25

  Hello, I would like a formula to say "OK" if Grade 1 is the highest grade compared to Grade 2 and Grade 3. What formula can I use please? Also...
• Remove characters from a file name

  • Started by gtd526
  • Sunday at 1:09 PM
  • Replies: 24

  Hello, How to remove characters from beginning of a file in a certain folder? I can identify the [U]folder[/U] from a cell. (myPath="A1") File...
• Math operation between a column with unique formulas and another column

  • Started by dejhantulip
  • Jul 4, 2020
  • Replies: 23

  Hello guys! So I've been having this situation quite often, and I have searched and thought of something to solve my problem but haven't been...
• how to export multiple sheets into txt files without the header line

  • Started by ankitaugust
  • Jul 4, 2020
  • Replies: 22

  Hi Folks- I am trying to figure out a simple way to export multiple sheets in my excel workbook without the header line. I was able to export the...