+ Post New Thread
Page 509 of 5623 FirstFirst ... 509 ...
Threads 25401 to 25450 of 281146

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

  1. [SOLVED] Find column title in a range and return the title of THAT column

    Started by bumchicken‎, 05-05-2021 05:20 AM
    2 Attachment(s)
    • 5
    • 341
    JohnTopley
    05-05-2021, 08:34 AM Go to last post

  2. [SOLVED] Identify the Spaces on Either Side of a Text String

    Started by Jakepr26‎, 05-03-2021 06:19 PM
    • 12
    • 462
    Fluff13
    05-05-2021, 08:25 AM Go to last post

  3. Calculate value based on multiple variables

    Started by tjdate‎, 05-04-2021 03:58 PM
    1 Attachment(s)
    • 3
    • 245
    kvsrinivasamurthy
    05-05-2021, 08:00 AM Go to last post

  4. Mailing Address Format

    Started by cjamps‎, 05-05-2021 06:42 AM
    • 1
    • 200
    Richard Buttrey
    05-05-2021, 06:47 AM Go to last post

  5. [SOLVED] Getting rounded numbers to add up

    Started by Marvo‎, 05-05-2021 06:00 AM
    1 Attachment(s)
    • 4
    • 302
    Marvo
    05-05-2021, 06:40 AM Go to last post

  6. [SOLVED] Summing horizontal ranges where the criteria is in a row

    Started by NJAFSL‎, 05-05-2021 06:05 AM
    1 Attachment(s)
    • 3
    • 181
    JohnTopley
    05-05-2021, 06:35 AM Go to last post

  7. Merge cells without losing data! How to do that?

    Started by bebo021999‎, 05-04-2021 11:17 PM
    4 Attachment(s)
    • 5
    • 697
    rorya
    05-05-2021, 05:29 AM Go to last post

  8. [SOLVED] Formula to susbtitute a word with another word via LOOKUP

    Started by codeBeast‎, 05-05-2021 05:02 AM
    lookup and autocomplete
    • 2
    • 249
    codeBeast
    05-05-2021, 05:20 AM Go to last post

  9. Linking two workbooks (Roster and Annual Leave) - formula/VBA- HELP REQUIRED

    Started by hboss_1‎, 05-05-2021 04:36 AM
    formulas, roster, vba, vlookup, workbook 2 Attachment(s)
    • 0
    • 353
    hboss_1
    05-05-2021, 04:36 AM Go to last post

  10. Field to sum a column

    Started by kevho1‎, 05-04-2021 10:19 PM
    • 3
    • 235
    davsth
    05-05-2021, 03:50 AM Go to last post

  11. Split data between phone number and next name

    Started by Leeta77‎, 04-30-2021 08:46 PM
    6 Attachment(s)
    • 11
    • 472
    kvsrinivasamurthy
    05-05-2021, 03:43 AM Go to last post

  12. [SOLVED] Match 3 sets of criteria for select relating to one name

    Started by rooboyz‎, 04-30-2021 01:15 AM
    10 Attachment(s)
    • 19
    • 558
    JohnTopley
    05-05-2021, 03:00 AM Go to last post

  13. [SOLVED] Dynamic formula to split data in column c and repeat the remaining columns

    Started by leprince2007‎, 05-03-2021 01:36 PM
    4 Attachment(s)
    • 5
    • 310
    leprince2007
    05-05-2021, 02:40 AM Go to last post

  14. [SOLVED] Formulas with Multiple Range Criteria - not returning result

    Started by btparkhe1920‎, 05-01-2021 02:09 AM
    3 Attachment(s)
    • 8
    • 456
    btparkhe1920
    05-05-2021, 01:55 AM Go to last post

  15. [SOLVED] Subtract aggregate of row between columns of values in different rows

    Started by jchriste11‎, 05-03-2021 11:52 PM
    2 Attachment(s)
    • 4
    • 256
    AliGW
    05-05-2021, 12:41 AM Go to last post

  16. Question Count amount of times "A/L" text appears in a row

    Started by King Mustard‎, 05-04-2021 07:59 AM
    1 Attachment(s)
    • 2
    • 217
    FlameRetired
    05-04-2021, 11:16 PM Go to last post

  17. Conditional formatting nested formula question - elseif

    Started by Nevski79‎, 05-04-2021 06:37 PM
    • 1
    • 178
    TMS
    05-04-2021, 06:52 PM Go to last post

  18. Question More efficient formula request

    Started by Doug-M‎, 04-30-2021 05:27 PM
    2 Attachment(s)
    • 8
    • 378
    Doug-M
    05-04-2021, 06:00 PM Go to last post

  19. Trying to create RAG Training Matrix

    Started by beckasimpson‎, 04-29-2021 07:57 AM
    2 Attachment(s)
    • 1
    • 347
    JeteMc
    05-04-2021, 05:22 PM Go to last post

  20. Conditional format project timeline based on milestone in sub task

    Started by tesa72‎, 05-04-2021 08:10 AM
    2 Attachment(s)
    • 9
    • 380
    JohnTopley
    05-04-2021, 04:28 PM Go to last post

  21. Consolidate multiple columns to one using formulas

    Started by PaulM100‎, 04-22-2021 06:02 AM
    2 Attachment(s)
    • 6
    • 615
    JohnTopley
    05-04-2021, 03:02 PM Go to last post

  22. Question why is my function greyed out?

    Started by eeps24‎, 05-04-2021 01:41 PM
    1 Attachment(s)
    • 1
    • 1,157
    Fluff13
    05-04-2021, 01:45 PM Go to last post

  23. How do I pull information from a list of cars sold to a different page for each salesman

    Started by RyanVB99‎, 04-28-2021 02:58 PM
    3 Attachment(s)
    • 3
    • 418
    JeteMc
    05-04-2021, 01:36 PM Go to last post

  24. [SOLVED] Vlookup column index number keeps changing when table expands

    Started by randall78‎, 05-04-2021 12:09 PM
    • 3
    • 283
    TMS
    05-04-2021, 12:19 PM Go to last post

  25. [SOLVED] Sumif specific value in ayear

    Started by Excl3454‎, 05-04-2021 12:04 PM
    sum and if, sumifs, sumifs & dates 2 Attachment(s)
    • 2
    • 415
    Excl3454
    05-04-2021, 12:17 PM Go to last post

  26. Calculating the SLA end date and time

    Started by leongti‎, 04-26-2013 10:38 AM
    1 Attachment(s)
    • 11
    • 7,229
    JeteMc
    05-04-2021, 11:51 AM Go to last post

  27. [SOLVED] Data Table Loan Amortisation

    Started by Howardc1001‎, 05-04-2021 09:08 AM
    2 Attachment(s)
    • 2
    • 203
    Howardc1001
    05-04-2021, 11:27 AM Go to last post

  28. [SOLVED] Countifs across columns and dependient on criteria

    Started by rayted‎, 05-04-2021 08:45 AM
    sumif 2 Attachment(s)
    • 6
    • 380
    JohnTopley
    05-04-2021, 09:17 AM Go to last post

  29. Cool [SOLVED] Transpose data in six columns into unique and multiple rows based on unique club name

    Started by JimmyB11‎, 04-28-2021 06:45 PM
    2 Attachment(s)
    • 4
    • 551
    JeteMc
    05-04-2021, 09:12 AM Go to last post

  30. [SOLVED] Sum with different criteria

    Started by DEEARO‎, 05-04-2021 06:01 AM
    1 Attachment(s)
    • 4
    • 255
    samba_ravi
    05-04-2021, 08:05 AM Go to last post

  31. data validation choose between restricted value and certain drop list based on another cel

    Started by moftah17‎, 05-03-2021 04:42 AM
    excel & formula
    • 4
    • 333
    JohnTopley
    05-04-2021, 05:57 AM Go to last post

  32. Using Excel to help to select lotto number - %

    Started by Aleksandar Aleksanda‎, 05-03-2021 02:25 PM
    1 Attachment(s)
    • 9
    • 362
    JohnTopley
    05-04-2021, 05:55 AM Go to last post

  33. [SOLVED] Cell auto-populated by dropdown list shows error but I would like it blank

    Started by Schroeder70‎, 05-04-2021 04:15 AM
    1 Attachment(s)
    • 5
    • 229
    Schroeder70
    05-04-2021, 05:23 AM Go to last post

  34. [SOLVED] Count description base on the DATE

    Started by jasond1992‎, 05-04-2021 02:24 AM
    4 Attachment(s)
    • 3
    • 264
    jasond1992
    05-04-2021, 02:52 AM Go to last post

  35. [SOLVED] Looking for to resolve the Match formula in attached file

    Started by suneeshpillai‎, 05-02-2021 09:07 AM
    2 Attachment(s)
    • 8
    • 357
    FDibbins
    05-04-2021, 01:45 AM Go to last post

  36. [SOLVED] How to count partial matches in single cell with multiple concatenated values?

    Started by therealdees‎, 05-01-2021 09:43 PM
    • 4
    • 293
    FDibbins
    05-04-2021, 01:45 AM Go to last post

  37. Substitute text

    Started by bambino86‎, 05-03-2021 11:58 PM
    1 Attachment(s)
    • 3
    • 327
    AliGW
    05-04-2021, 12:41 AM Go to last post

  38. calculate average excluding both Filtered rows & 0 value in cells

    Started by varunistician‎, 04-28-2021 09:48 PM
    1 Attachment(s)
    • 3
    • 637
    bebo021999
    05-03-2021, 10:44 PM Go to last post

  39. Displaying data from multiple sheets with multiple criteria

    Started by afreed33‎, 05-03-2021 07:31 PM
    aggregate, criteria as text, function 1 Attachment(s)
    • 2
    • 390
    thenewkidd
    05-03-2021, 08:23 PM Go to last post

  40. index/match formula to return variable/changing results from different sheet

    Started by Owen1976‎, 04-30-2021 09:19 AM
    3 Attachment(s)
    • 15
    • 445
    cubangt
    05-03-2021, 05:46 PM Go to last post

  41. Mixing organisational data types

    Started by samdthompson‎, 05-03-2021 02:32 PM
    data types
    • 2
    • 276
    samdthompson
    05-03-2021, 04:47 PM Go to last post

  42. [SOLVED] Formula to check width and length from multiple cells and return text

    Started by WAAZUPEE‎, 05-03-2021 11:45 AM
    1 Attachment(s)
    • 2
    • 228
    WAAZUPEE
    05-03-2021, 04:12 PM Go to last post

  43. Populating cells based on dependent drop down lists within a table

    Started by heapy41‎, 05-03-2021 03:40 PM
    1 Attachment(s)
    • 1
    • 213
    JohnTopley
    05-03-2021, 04:01 PM Go to last post

  44. [SOLVED] IFERROR Index and Match formula not returning expected result

    Started by Ron Purpura‎, 05-03-2021 03:36 PM
    1 Attachment(s)
    • 2
    • 200
    Ron Purpura
    05-03-2021, 03:52 PM Go to last post

  45. [SOLVED] Formula: Only count "Y"s in Column B if a certain criteria is met in Column A

    Started by Micky.ripley‎, 05-03-2021 12:59 PM
    countif, sumif 1 Attachment(s)
    • 6
    • 386
    Fluff13
    05-03-2021, 03:13 PM Go to last post

  46. Debt Repayment

    Started by Chandrashekhar‎, 05-27-2009 12:35 AM
    2 Attachment(s)
    • 2
    • 1,181
    JeteMc
    05-03-2021, 01:39 PM Go to last post

  47. Highest to 6 scores from 8 weeks

    Started by John Henworth‎, 05-03-2021 06:28 AM
    4 Attachment(s)
    • 8
    • 331
    Richard Buttrey
    05-03-2021, 12:56 PM Go to last post

  48. [SOLVED] Referencing cells

    Started by Schroeder70‎, 04-28-2021 03:35 PM
    1 Attachment(s)
    • 8
    • 416
    JohnTopley
    05-03-2021, 12:31 PM Go to last post

  49. using roundup on multiple formulas

    Started by Petewxm‎, 05-03-2021 08:58 AM
    • 6
    • 426
    AliGW
    05-03-2021, 11:59 AM Go to last post

  50. WTA : How is the formula in column amount with different percentage?

    Started by vrontire‎, 04-27-2021 10:58 PM
    2 Attachment(s)
    • 6
    • 327
    JeteMc
    05-03-2021, 11:41 AM Go to last post
+ Post New Thread
Page 509 of 5623 FirstFirst ... 509 ...

Forum Information and Options

Users Browsing this Forum

There are currently 59 users browsing this forum. (1 members & 58 guests)

  1. Phuocam

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