Search:

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

Search: Search took 0.00 seconds.

  1. Re: Grade compare two non blank cells with alphabets and report trend

    Thanks a lot @eric-w works perfectly.
    :smile:
  2. Grade compare two non blank cells with alphabets and report trend

    Dear MrExcelites,

    Greetings, I need a formula to compare the last and the last second cell and report whether it has increased or decreased or stays the same.

    Grade Table:
    <b></b><table...
  3. Replies
    8
    Views
    248

    Re: Grade using two range/conditions

    This too works, thanks a lot @rick-rothstein :)
  4. Replies
    8
    Views
    248

    Re: Grade using two range/conditions

    Thanks Fluff it works but table is used for visual ref only and I don't want to change the format of the file, since I'm sharing it to other people it would be hard for them to ref.
  5. Replies
    8
    Views
    248

    Re: Grade using two range/conditions

    Thanks jondavis1987 works like a charm.
  6. Replies
    8
    Views
    248

    Grade using two range/conditions

    Dear MrExcelits,

    Need help in deriving Grade A to E using two sets of data.
    Tried my best and stuck.
    Please help in formula.
    No macros please as I would share this file.

    Example as below:
    ...
  7. Re: Copy or Shift row values horizontally wrt first row value.

    Now that works well...
    Thanks a lot M
  8. Re: Copy or Shift row values horizontally wrt first row value.

    There 1 tiny problem.
    if the table is as below

    Excel 2016 (Windows) 32 bit

    A
    B
    C

    1CHARLIST-ALIST-B
  9. Re: Copy or Shift row values horizontally wrt first row value.

    Worked like charm, thanks a lot
  10. Re: Copy or Shift row values horizontally wrt first row value.

    Here after long time.
    Sorry for link
    below is table 1
    Excel 2016 (Windows) 32 bit

    A
    B
    C

    1CHARLIST-ALIST-B
  11. Copy or Shift row values horizontally wrt first row value.

    Hello Excelites.

    I have below table.

    https://ibb.co/kPVJmS

    which should look like below.

    https://ibb.co/kk9B6S
  12. Re: Populating cell depending on the value of a range

    Awesome, that worked like a charm, Thanks a lot.
  13. Re: Populating cell depending on the value of a range

    The resulting table should look like Table B. Does not work. thanks.
  14. Re: Populating cell depending on the value of a range

    The NUMBER column is a group like all the ABCD, ABCD-01 and ABCD-02 comes under ABCD, and so for IJKL AND IJKL-01 comes under IJKL. i.e., for Sl.No. 1 and 3 respectively.
    A2, A3 and A4 (ie, ABCD,...
  15. Populating cell depending on the value of a range

    Hi,

    I'm looking for a solution or a formula which could solve my problem.
    http://i358.photobucket.com/albums/oo21/ukbulldog001/PR_zpsrne4xoty.jpg
    I want the "STATUS" column to be populated as...
Results 1 to 15 of 15