Results 1 to 16 of 16

Max loss by month

Threaded View

  1. #6
    Forum Contributor
    Join Date
    07-29-2005
    Location
    Singapore
    MS-Off Ver
    2007
    Posts
    253

    Question Re: How to get max loss by month

    Hi Darkyam,

    Yup, you are right. There are data below my under the Column J after the P&L.

    By doing the multiply paste special, is it the same as changing all my IF to 1*IF in all the P&L under column J? I did try both ways but I still get #NA. I also notice my conditional formatting are gone. Did I do it wrongly?

    I have attached my sample here with the suggested solution.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1