+ Post New Thread
Page 493 of 5614 FirstFirst ... 493 ...
Threads 24601 to 24650 of 280690

Forum: Excel Formulas & Functions

Post and discuss Excel Formulas & functions.

  1. Thumbs up Sticky Thread Sticky: Excel Useful Links (see last post for new additions)

    Started by gopi_excel‎, 12-22-2006 08:14 PM
    • 19
    • 156,905
    VBA Noob
    10-10-2007, 11:36 AM Go to last post

  1. [SOLVED] Look-up and return data in a certain cell according to multiple criteria

    Started by Orif‎, 05-16-2021 10:38 AM
    excel formula how to, formula and functions, lookup 2 Attachment(s)
    • 5
    • 464
    Limor_OP
    05-16-2021, 01:20 PM Go to last post

  2. If(And(Index(Match...

    Started by Even‎, 05-16-2021 09:11 AM
    • 10
    • 401
    AliGW
    05-16-2021, 01:06 PM Go to last post

  3. [SOLVED] lookup + multiple results , approximate match , need solution please

    Started by mostafaghazy‎, 05-14-2021 05:19 PM
    2 Attachment(s)
    • 3
    • 343
    thenewkidd
    05-16-2021, 12:48 PM Go to last post

  4. If(Index(Match with multiple criterias

    Started by Even‎, 05-16-2021 12:25 PM
    1 Attachment(s)
    • 1
    • 195
    AliGW
    05-16-2021, 12:39 PM Go to last post

  5. Getting a formula to stop calculating after a certain point

    Started by Arnis‎, 04-15-2021 06:17 AM
    formula 1 Attachment(s)
    • 4
    • 579
    Limor_OP
    05-16-2021, 12:32 PM Go to last post

  6. Post [SOLVED] Comparing Unsorted Lists Across Multiple Sheets

    Started by farism‎, 05-14-2021 03:18 PM
    4 Attachment(s)
    • 12
    • 426
    alansidman
    05-16-2021, 11:53 AM Go to last post

  7. [SOLVED] Between two dates

    Started by Reykjavik‎, 05-16-2021 10:10 AM
    • 2
    • 240
    AliGW
    05-16-2021, 10:58 AM Go to last post

  8. Formula to pull data from different sheets to one

    Started by paycep86‎, 05-15-2021 06:37 AM
    3 Attachment(s)
    • 6
    • 397
    JohnTopley
    05-16-2021, 06:48 AM Go to last post

  9. Moved: Question about using VBA in Excel to change the value in a looked up cell

    Started by ExReey‎, 05-15-2021 04:10 PM
    •  
    •  

  10. [SOLVED] Monthly Growth

    Started by kashh83‎, 05-15-2021 09:12 AM
    1 Attachment(s)
    • 5
    • 388
    kashh83
    05-16-2021, 04:20 AM Go to last post

  11. Pull from Row from one Sheet to Another Array Formula ?

    Started by jphilipson‎, 05-16-2021 01:02 AM
    pulling data 2 Attachment(s)
    • 2
    • 345
    Bo_Ry
    05-16-2021, 01:26 AM Go to last post

  12. Possible VLOOKUP Function? Trying to search through multiple sheets

    Started by Mattchuex‎, 05-13-2021 04:36 PM
    5 Attachment(s)
    • 9
    • 438
    thenewkidd
    05-15-2021, 09:41 PM Go to last post

  13. [SOLVED] split up RS-232 Data to different columns

    Started by CJdR‎, 05-15-2021 03:00 PM
    add cell to column, power query, rs232 data, search specific cells 2 Attachment(s)
    • 3
    • 359
    alansidman
    05-15-2021, 07:42 PM Go to last post

  14. [SOLVED] Question about =IFS() having trouble with my formula!

    Started by JoeKerr99‎, 05-15-2021 02:48 PM
    greater than and equal to, ifs, ifs formula, less than and equal to
    • 3
    • 312
    JohnTopley
    05-15-2021, 03:05 PM Go to last post

  15. [SOLVED] Matching month amounts

    Started by sunboy‎, 05-15-2021 02:20 PM
    1 Attachment(s)
    • 3
    • 314
    sunboy
    05-15-2021, 03:03 PM Go to last post

  16. [SOLVED] Formula that return the difference in a set of numbers closest to it

    Started by lar9149‎, 05-15-2021 10:17 AM
    2 Attachment(s)
    • 2
    • 292
    lar9149
    05-15-2021, 12:13 PM Go to last post

  17. Smile Help with Sigma fuction

    Started by Zalachenko‎, 05-15-2021 08:22 AM
    2 Attachment(s)
    • 4
    • 274
    MrShorty
    05-15-2021, 11:31 AM Go to last post

  18. [SOLVED] Formula that sums the 2 far left numbers in a given range than the 2nd most left & so on

    Started by lar9149‎, 05-14-2021 12:20 AM
    1 Attachment(s)
    • 2
    • 320
    lar9149
    05-15-2021, 10:00 AM Go to last post

  19. [SOLVED] Hepl on if formula

    Started by sunboy‎, 05-15-2021 08:21 AM
    1 Attachment(s)
    • 2
    • 268
    sunboy
    05-15-2021, 08:43 AM Go to last post

  20. I want to Remove every 5 rows from my excel sheet. Is there a way to automate it?

    Started by ExcelBeats‎, 05-14-2021 05:45 AM
    1 Attachment(s)
    • 12
    • 327
    JohnTopley
    05-15-2021, 08:02 AM Go to last post

  21. Question On Index Formula

    Started by ExcelBeats‎, 05-15-2021 06:47 AM
    2 Attachment(s)
    • 13
    • 295
    JohnTopley
    05-15-2021, 08:00 AM Go to last post

  22. [SOLVED] Formula not counting all relevant data

    Started by Ochimus‎, 05-14-2021 10:51 AM
    2 Attachment(s)
    • 2
    • 245
    Ochimus
    05-15-2021, 07:22 AM Go to last post

  23. [SOLVED] SUM not working correctly

    Started by AppieTokkkie‎, 05-14-2021 07:45 PM
    1 Attachment(s)
    • 2
    • 282
    AppieTokkkie
    05-15-2021, 07:02 AM Go to last post

  24. Price Menu -Dependent drop downs with lookup function based on multiple selections

    Started by fuadramsey‎, 05-13-2021 07:35 PM
    dependent drop down, lookup, match & index 4 Attachment(s)
    • 6
    • 520
    JohnTopley
    05-15-2021, 06:44 AM Go to last post

  25. Count the data of a group with multiple conditions

    Started by suneeshpillai‎, 05-13-2021 11:16 PM
    2 Attachment(s)
    • 3
    • 301
    JohnTopley
    05-15-2021, 05:43 AM Go to last post

  26. [SOLVED] Using countifs with specific criteria

    Started by geniusufo007‎, 05-15-2021 03:16 AM
    3 Attachment(s)
    • 5
    • 314
    sohaila
    05-15-2021, 04:18 AM Go to last post

  27. How not to update the column in basic formula?

    Started by Smurk‎, 05-12-2021 07:15 AM
    2 Attachment(s)
    • 4
    • 292
    JohnTopley
    05-15-2021, 03:15 AM Go to last post

  28. Splitting customers to lists and even value on lists.

    Started by essendon21‎, 05-14-2021 02:06 AM
    2 Attachment(s)
    • 2
    • 250
    josephteh
    05-15-2021, 01:26 AM Go to last post

  29. [SOLVED] If this AND that

    Started by farhadj‎, 05-14-2021 04:07 PM
    • 3
    • 246
    AliGW
    05-15-2021, 12:41 AM Go to last post

  30. [SOLVED] Trying to populate cells in a specific order on a sheet with data from an unsorted sheet

    Started by clark402‎, 05-14-2021 01:11 AM
    1 Attachment(s)
    • 4
    • 276
    AliGW
    05-15-2021, 12:28 AM Go to last post

  31. SUMIFS with ">=date" Criteria

    Started by Brewttv‎, 05-14-2021 05:35 PM
    • 1
    • 225
    hrlngrv
    05-14-2021, 06:51 PM Go to last post

  32. Question returning unique value with multiple criteria

    Started by Sundevil1982‎, 05-11-2021 04:50 PM
    6 Attachment(s)
    • 11
    • 469
    LeeMcG
    05-14-2021, 06:43 PM Go to last post

  33. Updating phasing profile

    Started by managingcrap‎, 05-12-2021 08:15 AM
    1 Attachment(s)
    • 1
    • 248
    JeteMc
    05-14-2021, 06:22 PM Go to last post

  34. SUMIFS Help Needed

    Started by ronnysmith884‎, 05-14-2021 05:17 PM
    • 2
    • 232
    hrlngrv
    05-14-2021, 06:18 PM Go to last post

  35. [SOLVED] Rank formula error (misses duplicate values)

    Started by Median‎, 05-14-2021 01:56 PM
    1 Attachment(s)
    • 3
    • 292
    ChemistB
    05-14-2021, 04:07 PM Go to last post

  36. [SOLVED] Formula in a cell to convert all data from columns in one with commas seperated

    Started by fulldeen‎, 05-14-2021 03:21 PM
    • 3
    • 255
    fulldeen
    05-14-2021, 04:07 PM Go to last post

  37. [SOLVED] Formula changing range criteria when dragging down. Need to freeze range.

    Started by TENOH‎, 05-14-2021 03:50 PM
    • 1
    • 211
    TENOH
    05-14-2021, 03:54 PM Go to last post

  38. Formula that returns 1,2 or blank depending on matched pairs

    Started by lar9149‎, 05-13-2021 05:19 PM
    1 Attachment(s)
    • 6
    • 330
    lar9149
    05-14-2021, 02:58 PM Go to last post

  39. [SOLVED] Formula based on color

    Started by Daniel-1973‎, 05-13-2021 04:30 PM
    color, formula, recognition 3 Attachment(s)
    • 6
    • 465
    Daniel-1973
    05-14-2021, 02:55 PM Go to last post

  40. looking to import data if equal to valve and then skip line if not

    Started by kingr13‎, 05-13-2021 08:40 PM
    • 1
    • 198
    JohnTopley
    05-14-2021, 02:37 PM Go to last post

  41. Question [SOLVED] Giving Cells Numerical Values

    Started by anmasias‎, 05-13-2021 05:53 PM
    1 Attachment(s)
    • 4
    • 232
    alansidman
    05-14-2021, 02:16 PM Go to last post

  42. [SOLVED] Calculate and Return decimal value between range

    Started by Aquarock‎, 05-14-2021 10:06 AM
    6 Attachment(s)
    • 8
    • 337
    Aquarock
    05-14-2021, 01:53 PM Go to last post

  43. Calculating total amount based off category selection

    Started by davidstokes‎, 05-14-2021 11:59 AM
    1 Attachment(s)
    • 2
    • 256
    davidstokes
    05-14-2021, 01:39 PM Go to last post

  44. Index & Match 3 way look up?

    Started by Redlittle‎, 05-14-2021 11:51 AM
    • 4
    • 350
    Fluff13
    05-14-2021, 01:16 PM Go to last post

  45. Question Randomly pick from a list with two criteria?

    Started by cappaert‎, 05-14-2021 12:07 PM
    2 Attachment(s)
    • 3
    • 211
    alansidman
    05-14-2021, 01:06 PM Go to last post

  46. Question sumproduct using filters

    Started by JerryJP‎, 05-14-2021 10:39 AM
    sumproduct & frequency 2 Attachment(s)
    • 3
    • 195
    ChemistB
    05-14-2021, 01:03 PM Go to last post

  47. UPC Barcode Check Digit as a conditional format

    Started by help_at_work‎, 05-13-2021 02:49 PM
    barcode, check digit, conditional format, upc 5 Attachment(s)
    • 15
    • 2,053
    help_at_work
    05-14-2021, 12:24 PM Go to last post

  48. formula needed to assign a number based on value and then add those numbers

    Started by pwick‎, 05-12-2021 01:09 AM
    1 Attachment(s)
    • 3
    • 281
    JeteMc
    05-14-2021, 12:08 PM Go to last post

  49. Iferror

    Started by preveo‎, 05-14-2021 08:50 AM
    • 3
    • 248
    AliGW
    05-14-2021, 11:40 AM Go to last post

  50. Large with Multiple Criteria

    Started by gotiono‎, 05-11-2021 02:35 PM
    • 4
    • 290
    JeteMc
    05-14-2021, 11:31 AM Go to last post
+ Post New Thread
Page 493 of 5614 FirstFirst ... 493 ...

Forum Information and Options

Users Browsing this Forum

There are currently 60 users browsing this forum. (4 members & 56 guests)

  1. etaf,
  2. JohnTopley,
  3. Phuocam,
  4. Rick Rothstein

Thread Display Options

Use this control to limit the display of threads to those newer than the specified time frame.

Allows you to choose the data by which the thread list will be sorted.

Order threads in...

Note: when sorting by date, 'descending order' will show the newest results first.

Icon Legend

Contains unread posts
Contains unread posts
Contains no unread posts
Contains no unread posts
More than 15 replies or 150 views
Hot thread with unread posts
More than 15 replies or 150 views
Hot thread with no unread posts
Closed Thread
Thread is closed
Thread Contains a Message Written By You
You have posted in this thread

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1