Search:

Type: Posts; User: HMSTPI; Keyword(s):

Search: Search took 0.00 seconds.

  1. Re: Excrutiatingly slow insert/delete times using table and defined names

    file size is < 700KB
  2. Re: Excrutiatingly slow insert/delete times using table and defined names

    try this -- using personal instead of company that wouldn't allow me to share with anyone.
    https://1drv.ms/x/s!ArBWadL4zwPHryNzYIMsewHU_Dt5
  3. Re: Excrutiatingly slow insert/delete times using table and defined names

    shoot -- it didn't tell me that .. I can't say that I've ever shared a file other than from one-drive that I guess would always require a login. Where /how else would I do that?
  4. Re: Excrutiatingly slow insert/delete times using table and defined names

    none whatsoever.
    ...
  5. Excrutiatingly slow insert/delete times using table and defined names

    I have a file that is taking longer and longer to insert/delete/move cells/columns/rows now up to at least 10 minutes EVERY SINGLE TIME! I have tried absolutely EVERYTHING that I can find and am at...
  6. Re: How to make ISFORMULA conditional format exclude 'manual' formulas

    OH -- have to substitute the "." for "" also :)

    =ISERR(VALUE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(FORMULATEXT(Cell),".",""),"=",""),"+",""),"-","")))
  7. Re: How to make ISFORMULA conditional format exclude 'manual' formulas

    Those didn't work because the real formulas can have either/both parenthesis and +. So I kept trying and got this to work:
    ...
  8. How to make ISFORMULA conditional format exclude 'manual' formulas

    I have a conditional format in Excel 2016 set to shade cells that are formulas using the ISFORMULA() function. However, it also shades cells that include two manually input values added --- i.e....
  9. Re: COUNTIF in a list that contains numbers formatted as text

    Neither option seem to give the right answer. I ended up having to create a different field to concatenate some text in front of the real sorting target to get it to work. All the years I've...
  10. COUNTIF in a list that contains numbers formatted as text

    Excel 2013 64-Bit: I have a list of text that will NOT count correctly (to get the alphabetical order) and, for the first time I know of, I am unable to find any previous discussion anywhere that is...
Results 1 to 10 of 10