News, tips, advice, support for Windows, Office, PCs & more. Tech help. No bull. We're community supported by donations from our Plus Members, and proud of it
Home icon Home icon Home icon Email icon RSS icon
  • rjstorms

    Forum Replies Created

    Viewing 15 posts - 1 through 15 (of 108 total)
    • Author
      Posts
    • in reply to: Need Help w/Excel 2003 Formula #1961906

      rjstorms
      AskWoody Plus

      Thank you very much, zeddy, for your help with my worksheet problems. Your solutions worked really well, and I appreciate it very much.
      I did make one slight adjustment, however, to your last suggestion. Rather than use conditional formatting to color the entire cell white, I modified it to just make the font white.
      Thanks again for your help.
      Robert

    • in reply to: Need Help w/Excel 2003 Formula #1952713

      rjstorms
      AskWoody Plus

      Sorry, zeddy, for my delay in responding to your most recent input. I’ve been incorporating your recommended formulas into my (very large!) worksheet, which I’ve revised slightly as shown in cells J47:U64 of my Updated Sample Worksheet, attached.

      All your recommendations work perfectly, but I have run in to one final (I hope!) problem: I have a formula entered in column G8:G43 of the sample worksheet wherein the cell is blank if there is no entry in column E. I need this formula to be extended in column G to the very end of the worksheet.

      Note that when I remove the formula in G44:G55, shaded in pink, as I have done, my desired results will show as desired in the other four ranges that are also shaded in pink. But, when I extend the formula in column G to cells G44:G55, the array formulas in the shaded ranges do not work. Apparently array formulas will not work when a formula is entered in one of the ranges.

      How can I correct this new problem? Thanks for your help.

      Robert

      Attachments:
    • in reply to: Need Help w/Excel 2003 Formula #1934627

      rjstorms
      AskWoody Plus

      Thanks, PaulB, for your reply.

      Please see my attached Sample Worksheet #2.

      I used your recommended formulas in my sample worksheet. They all seem to work fine except they will not work when the difference = 0. See cells K32:K43.

      Please also see my note in cell J24.

      Thanks for your help.
      Robert

      Attachments:
    • in reply to: Need Help w/Excel 2003 Formula #1848971

      rjstorms
      AskWoody Plus

      [SOLVED]
      Thank you, Kirsty, for your follow-up reply and suggestion on how to tweak the formula that debaser suggested in his earlier reply. It works great and solves my problem!

      1 user thanked author for this post.
    • in reply to: “Disallowed Key Characters” Link Error #1536499

      rjstorms
      AskWoody Plus

      Thanks for the reply. I’ll try to contact them. I tried once before, but got no response.
      Robert

    • in reply to: Need Help With 2 Excel 2003 Formulas #1466198

      rjstorms
      AskWoody Plus

      Thank you very much! Works like a charm!
      This was driving me crazy – just a little below my skill level with context details.
      Robert

    • in reply to: Need Help w/Excel 2003 Formula #1848972

      rjstorms
      AskWoody Plus

      [SOLVED]
      Debaser – your formula does work great after all. It just needed to be tweaked a little as explained in Kirsty’s recent follow-up reply.

    • in reply to: Need Help w/Excel 2003 Formula #1847809

      rjstorms
      AskWoody Plus

      Thanks for your reply, debaser. I am unable to enter your formula in my spreadsheet because I get a notice that there is an error in my formula and the double quotation marks “” following the & are highlighted to indicate where the error is. Can’t figure out what the problem is. I originally thought that your formula was the most promising (other than zeddy’s solution). Perhaps it just needs some tweaking.

    • in reply to: Need Help w/Excel 2003 Formula #1847808

      rjstorms
      AskWoody Plus

      Thank you for your reply, Zeddy. This solution appears that it will return the desired result. However, my spreadsheet is already so large and complicated that I prefer not to have to rely on “helper columns” unless I absolutely have to. Ultimately I may have to. But in the meantime I will continue to try to find another formula solution as I also have additional same-scenario-columns that also require a similar formula.
      Thanks again, Zeddy.

    • in reply to: Need Help w/Excel 2003 Formula #1847807

      rjstorms
      AskWoody Plus

      Thanks for your reply, Kirsty. I tried that as follows, but is still does not produce the desired result. It returns a #VALUE! error.
      =IF(D42:D1000=””,””,IF(N42:N1000=””,””,LOOKUP(2,1/(N42:N1000=AE12),D42:D1000)))

    • in reply to: Closest Match Formula #1592513

      rjstorms
      AskWoody Plus

      Thanks, zeddy. Worked like a charm! I always have a difficult time understanding and using the Index and Match functions!

    • in reply to: Need Page Numbers To Print On .pdf Document #1490767

      rjstorms
      AskWoody Plus

      Thanks for the reply. Print setup does not give that option.
      Robert

    • in reply to: Need Page Numbers To Print On .pdf Document #1490766

      rjstorms
      AskWoody Plus

      Thanks for the reply, but that price is too much for a one-time need.
      Robert

    • in reply to: Need Help With 2 Excel 2003 Formulas #1466194

      rjstorms
      AskWoody Plus

      Thanks again for the reply, but the issue is still not resolved.
      You are correct – COUNTIFS function does not work in Excel 2003, which is my version.
      Any other ideas, or can anyone else help?

      Robert

    • in reply to: Need Help With 2 Excel 2003 Formulas #1466190

      rjstorms
      AskWoody Plus

      Correction –
      Formula 2 should return 4
      Robert

    Viewing 15 posts - 1 through 15 (of 108 total)