+ Post New Thread
Page 397 of 5627 FirstFirst ... 397 ...
Threads 19801 to 19850 of 281329

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
    • 157,265
    VBA Noob
    10-10-2007, 11:36 AM Go to last post

  1. Need formula to match four criteria

    Started by saravanan1981‎, 12-13-2021 06:15 AM
    2 Attachment(s)
    • 2
    • 234
    JohnTopley
    12-14-2021, 01:42 AM Go to last post

  2. [SOLVED] Is there a formula to decode URL's?

    Started by mikey42979‎, 06-11-2014 04:31 PM
    • 20
    • 27,759
    pitspoon
    12-14-2021, 01:15 AM Go to last post

  3. [SOLVED] Finding non-proportional values within a max/min range

    Started by Pr0‎, 12-13-2021 01:30 PM
    4 Attachment(s)
    • 3
    • 281
    Czeslaw
    12-14-2021, 12:28 AM Go to last post

  4. Need help merging two lists to a third custom list with calculated fields.

    Started by kostas90‎, 12-10-2021 10:48 AM
    3 Attachment(s)
    • 3
    • 309
    DJunqueira
    12-13-2021, 09:35 PM Go to last post

  5. [SOLVED] Formulas to auto sort values

    Started by cmyers5613‎, 12-13-2021 02:05 PM
    1 Attachment(s)
    • 3
    • 267
    Pete_UK
    12-13-2021, 09:12 PM Go to last post

  6. [SOLVED] Countifs greater than and less than

    Started by jmcole‎, 12-13-2021 03:35 PM
    • 3
    • 283
    Estevaoba
    12-13-2021, 08:30 PM Go to last post

  7. Vlookup and moving to a new cell once cell contains nothing

    Started by DaveCVB‎, 12-13-2021 02:25 PM
    2 Attachment(s)
    • 1
    • 177
    DJunqueira
    12-13-2021, 05:06 PM Go to last post

  8. [SOLVED] simple sum based on a variable set of rows

    Started by bopsgtir‎, 12-13-2021 07:04 AM
    • 3
    • 238
    bopsgtir
    12-13-2021, 04:53 PM Go to last post

  9. [SOLVED] Filter for "Contains ONLY X"

    Started by jomili‎, 12-13-2021 03:03 PM
    1 Attachment(s)
    • 3
    • 198
    Fluff13
    12-13-2021, 03:57 PM Go to last post

  10. Countifs with blank criteria.

    Started by TimH27‎, 12-09-2021 07:23 AM
    2 Attachment(s)
    • 6
    • 404
    JeteMc
    12-13-2021, 02:08 PM Go to last post

  11. Top 10 table instead of pie chart

    Started by charlieexcels‎, 12-13-2021 11:13 AM
    3 Attachment(s)
    • 2
    • 229
    charlieexcels
    12-13-2021, 01:16 PM Go to last post

  12. [SOLVED] Removing text from numbers

    Started by EvansB‎, 12-13-2021 12:19 PM
    1 Attachment(s)
    • 2
    • 254
    EvansB
    12-13-2021, 12:58 PM Go to last post

  13. [SOLVED] Nested IF (with AND) statements not working

    Started by TrojanHorse8806‎, 12-13-2021 12:00 PM
    1 Attachment(s)
    • 3
    • 188
    6StringJazzer
    12-13-2021, 12:38 PM Go to last post

  14. COUNTIF - Remove counted items if a condition is met.

    Started by UnrealFrost‎, 12-10-2021 07:04 AM
    1 Attachment(s)
    • 3
    • 270
    JeteMc
    12-13-2021, 11:42 AM Go to last post

  15. [SOLVED] Rolling total for previous 12 months

    Started by Damoon‎, 12-08-2021 03:26 AM
    2 Attachment(s)
    • 12
    • 435
    JeteMc
    12-13-2021, 10:05 AM Go to last post

  16. Challenge Creating a top 10 of sales volumes and accounts if there are identical sales.

    Started by CurtG‎, 12-12-2021 07:41 PM
    2 Attachment(s)
    • 4
    • 305
    Fluff13
    12-13-2021, 09:24 AM Go to last post

  17. % difference between two numbers and correct DIV

    Started by davidc4470‎, 12-13-2021 08:55 AM
    • 1
    • 190
    etaf
    12-13-2021, 08:58 AM Go to last post

  18. Do I use an INDEX/MATCH function or XLOOKUP for this example?

    Started by Majestic1976‎, 12-13-2021 05:15 AM
    1 Attachment(s)
    • 4
    • 352
    Fluff13
    12-13-2021, 08:57 AM Go to last post

  19. [SOLVED] Xlookup for two criteria vertical and horizontal

    Started by gjjh25‎, 12-10-2021 12:18 PM
    2 Attachment(s)
    • 5
    • 1,382
    Fluff13
    12-13-2021, 08:47 AM Go to last post

  20. PLEASE HELP EXAM MONday AND IM LOST

    Started by canadianmoose94‎, 12-10-2021 04:56 PM
    1 Attachment(s)
    • 4
    • 362
    davsth
    12-13-2021, 08:41 AM Go to last post

  21. Im getting a #N/A error on this index/match formula

    Started by survah‎, 12-12-2021 01:02 AM
    1 Attachment(s)
    • 4
    • 310
    davsth
    12-13-2021, 07:59 AM Go to last post

  22. Question [SOLVED] Lookup to match 2 criteria

    Started by lah81uk‎, 12-10-2021 01:38 PM
    1 Attachment(s)
    • 6
    • 273
    lah81uk
    12-13-2021, 06:01 AM Go to last post

  23. [SOLVED] conditional format with "applies to" that changes

    Started by kevinu‎, 05-08-2017 04:00 PM
    2 Attachment(s)
    • 13
    • 2,533
    AliGW
    12-13-2021, 05:39 AM Go to last post

  24. [SOLVED] Nested if statements and their sums

    Started by excelmefast‎, 12-13-2021 03:20 AM
    nested if and functions 2 Attachment(s)
    • 5
    • 352
    AliGW
    12-13-2021, 05:38 AM Go to last post

  25. Lightbulb Try create Price Offer table

    Started by Fresh87‎, 12-13-2021 03:47 AM
    1 Attachment(s)
    • 3
    • 212
    AliGW
    12-13-2021, 05:09 AM Go to last post

  26. need macro to execute multiple commands for 2 tabs in one spreadsheet

    Started by tonyk1051‎, 12-12-2021 10:59 AM
    1 Attachment(s)
    • 6
    • 337
    kvsrinivasamurthy
    12-13-2021, 03:06 AM Go to last post

  27. Question [SOLVED] Text Matching two tables multiple text parts?

    Started by exceldrdr‎, 12-12-2021 07:44 AM
    1 Attachment(s)
    • 8
    • 317
    JohnTopley
    12-13-2021, 02:48 AM Go to last post

  28. Rank With Multiple Criteria Without Duplicates

    Started by appletree943‎, 12-12-2021 07:19 PM
    countifs, excel, formula, rankif 2 Attachment(s)
    • 3
    • 381
    DJunqueira
    12-12-2021, 08:28 PM Go to last post

  29. [SOLVED] Distribution of values up to 10

    Started by Berna11‎, 12-10-2021 01:21 PM
    4 Attachment(s)
    • 6
    • 1,580
    Berna11
    12-12-2021, 04:56 PM Go to last post

  30. sorting on sub-fields

    Started by guthrie‎, 12-10-2021 06:13 PM
    • 1
    • 219
    dflak
    12-12-2021, 04:50 PM Go to last post

  31. Sum down a column return Date on matching Row

    Started by Tybudd‎, 12-09-2021 03:23 PM
    4 Attachment(s)
    • 12
    • 347
    DJunqueira
    12-12-2021, 02:03 PM Go to last post

  32. [SOLVED] MIN & MAX from Comma Separated Values in Cell

    Started by ranjan20‎, 12-11-2021 09:05 AM
    5 Attachment(s)
    • 6
    • 479
    DJunqueira
    12-12-2021, 12:28 PM Go to last post

  33. Exclamation Need help in formula completion of the Sales form

    Started by abhilashdas‎, 12-11-2021 05:24 PM
    2 Attachment(s)
    • 3
    • 248
    kvsrinivasamurthy
    12-12-2021, 12:10 PM Go to last post

  34. Exclamation Addition of Dates using IF function

    Started by abhilashdas‎, 12-12-2021 10:39 AM
    2 Attachment(s)
    • 2
    • 181
    JohnTopley
    12-12-2021, 10:52 AM Go to last post

  35. Transpose Data Table Arrange 1 Row into multiple Row.

    Started by Ronnieooi‎, 12-11-2021 10:38 PM
    3 Attachment(s)
    • 4
    • 261
    Gregb11
    12-12-2021, 10:50 AM Go to last post

  36. [SOLVED] IF with dates and conditions

    Started by Nours‎, 12-12-2021 03:49 AM
    2 Attachment(s)
    • 11
    • 253
    Nours
    12-12-2021, 08:53 AM Go to last post

  37. [SOLVED] Data Split - Blank lines issue

    Started by walshyrigger‎, 12-11-2021 09:08 AM
    blanks, data, format, split 1 Attachment(s)
    • 10
    • 626
    TMS
    12-12-2021, 06:22 AM Go to last post

  38. Using index match function in same row calculation

    Started by rehan0129‎, 12-12-2021 05:22 AM
    bar bending schedule, bbs 2 Attachment(s)
    • 2
    • 225
    bsalv
    12-12-2021, 05:34 AM Go to last post

  39. [SOLVED] conditional formatting for sun

    Started by geniusufo007‎, 12-11-2021 11:58 PM
    2 Attachment(s)
    • 3
    • 234
    geniusufo007
    12-12-2021, 12:28 AM Go to last post

  40. [SOLVED] Function fails to calculate vat

    Started by And180y‎, 12-11-2021 01:10 PM
    • 4
    • 274
    Richard Buttrey
    12-11-2021, 02:22 PM Go to last post

  41. Question [SOLVED] Maximum of coherent cells

    Started by moloto80‎, 12-09-2021 05:09 PM
    coherent, maximum
    • 4
    • 353
    moloto80
    12-11-2021, 09:32 AM Go to last post

  42. [SOLVED] Average based on comma separated values present in same cell

    Started by ranjan20‎, 12-08-2021 04:31 PM
    10 Attachment(s)
    • 29
    • 1,974
    AliGW
    12-11-2021, 09:11 AM Go to last post

  43. [SOLVED] Calculate price per hour if first hour is more?

    Started by waldzwastaken‎, 12-11-2021 08:04 AM
    1 Attachment(s)
    • 3
    • 232
    waldzwastaken
    12-11-2021, 09:04 AM Go to last post

  44. Formula to calculate tonnage operated per 24 hours

    Started by RobertGHD‎, 12-10-2021 07:50 AM
    5 Attachment(s)
    • 4
    • 978
    bsalv
    12-11-2021, 07:47 AM Go to last post

  45. Copy and Paste Retain certain Cells Values in a Formula

    Started by Tekulte‎, 12-10-2021 07:29 AM
    1 Attachment(s)
    • 3
    • 262
    Tekulte
    12-11-2021, 07:35 AM Go to last post

  46. [SOLVED] search partial of cell in another column then return value

    Started by mazan2010‎, 12-11-2021 06:39 AM
    2 Attachment(s)
    • 4
    • 223
    mazan2010
    12-11-2021, 07:13 AM Go to last post

  47. Lightbulb Find matching cell contents in a 2D array and returning the rows in a horizontal array

    Started by MacClaus‎, 12-11-2021 03:46 AM
    4 Attachment(s)
    • 7
    • 616
    AliGW
    12-11-2021, 06:45 AM Go to last post

  48. [SOLVED] Formula Required for LATE IN, EARLY OUT, ON TIME

    Started by raeesasif2022‎, 12-09-2021 03:46 PM
    1 Attachment(s)
    • 2
    • 738
    raeesasif2022
    12-11-2021, 06:27 AM Go to last post

  49. [SOLVED] Excel Formula - Flag the first duplicate

    Started by Abdur_rahman‎, 12-11-2021 04:25 AM
    2 Attachment(s)
    • 4
    • 345
    BadlySpelledBuoy
    12-11-2021, 05:09 AM Go to last post

  50. Smile [SOLVED] fill blank cells in a column by duplicating values of first unique instance

    Started by hasan mougharbel‎, 12-11-2021 03:00 AM
    1 Attachment(s)
    • 2
    • 249
    hasan mougharbel
    12-11-2021, 03:46 AM Go to last post
+ Post New Thread
Page 397 of 5627 FirstFirst ... 397 ...

Forum Information and Options

Users Browsing this Forum

There are currently 63 users browsing this forum. (0 members & 63 guests)

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