+ Post New Thread
Page 592 of 5619 FirstFirst ... 592 ...
Threads 29551 to 29600 of 280931

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

  1. [SOLVED] Non-Consecutive Count

    Started by yukibare‎, 12-11-2020 06:40 AM
    6 Attachment(s)
    • 29
    • 678
    yukibare
    12-11-2020, 04:52 PM Go to last post

  2. Count how many cells contain all of these characters

    Started by BBUK‎, 12-11-2020 03:44 PM
    • 1
    • 215
    CARACALLA
    12-11-2020, 04:42 PM Go to last post

  3. [SOLVED] Formula to add latest data input

    Started by Marvo‎, 12-10-2020 06:48 AM
    4 Attachment(s)
    • 30
    • 642
    Marvo
    12-11-2020, 04:01 PM Go to last post

  4. [SOLVED] Count until criteria from right to left

    Started by _Dice_‎, 12-11-2020 03:25 PM
    count, index, match 1 Attachment(s)
    • 2
    • 840
    _Dice_
    12-11-2020, 03:49 PM Go to last post

  5. Combining Multiple cells into one

    Started by Squint‎, 12-11-2020 03:01 PM
    1 Attachment(s)
    • 4
    • 235
    ChemistB
    12-11-2020, 03:36 PM Go to last post

  6. Help to maybe use vlookup to quickly copy prices from table b to a

    Started by Nanaya_shiki‎, 12-11-2020 10:42 AM
    3 Attachment(s)
    • 4
    • 247
    Mgc26133
    12-11-2020, 12:56 PM Go to last post

  7. Numbering a Column

    Started by martijnrikkert‎, 12-11-2020 11:30 AM
    2 Attachment(s)
    • 4
    • 278
    Bo_Ry
    12-11-2020, 12:48 PM Go to last post

  8. How can I use INDEX&MATCH to populate dropdown list with multiple values?

    Started by AleXSR700‎, 11-24-2020 07:11 AM
    4 Attachment(s)
    • 13
    • 604
    JeteMc
    12-11-2020, 12:43 PM Go to last post

  9. Average, mins, and maxes for criteria A *OR* B

    Started by ASmithO1‎, 12-10-2020 01:18 PM
    average, criteria, formula, max, min 6 Attachment(s)
    • 6
    • 598
    ASmithO1
    12-11-2020, 12:30 PM Go to last post

  10. Post Nested If Formula problem

    Started by ARCDad‎, 12-09-2020 09:44 PM
    • 3
    • 301
    ARCDad
    12-11-2020, 12:25 PM Go to last post

  11. Is it possible to format font of text within formula?

    Started by AleXSR700‎, 12-11-2020 12:08 PM
    • 2
    • 356
    Glenn Kennedy
    12-11-2020, 12:22 PM Go to last post

  12. [SOLVED] Arrange data in columns B and C against a linear timeline in column A

    Started by rtfm‎, 12-11-2020 10:36 AM
    align, columns, match 2 Attachment(s)
    • 5
    • 547
    Pete_UK
    12-11-2020, 12:16 PM Go to last post

  13. Question [SOLVED] Vertical values, horizontal formula, every nth value

    Started by faoiltiama‎, 12-11-2020 10:47 AM
    3 Attachment(s)
    • 7
    • 264
    kvsrinivasamurthy
    12-11-2020, 11:32 AM Go to last post

  14. [SOLVED] sum values on a culumn based on cretiria from another column

    Started by aeimisgr‎, 12-11-2020 07:22 AM
    1 Attachment(s)
    • 15
    • 387
    Pete_UK
    12-11-2020, 10:55 AM Go to last post

  15. [SOLVED] When a cell value is cut-n-pasted into a new cell dependant formula issues a '#REF'

    Started by chuckf201‎, 12-10-2020 02:44 PM
    excel formula error
    • 7
    • 969
    chuckf201
    12-11-2020, 10:37 AM Go to last post

  16. Another way of getting CHIDIST output

    Started by Chkalx‎, 12-11-2020 09:10 AM
    • 1
    • 251
    MrShorty
    12-11-2020, 10:17 AM Go to last post

  17. IF and IFS help please

    Started by maximus84‎, 12-11-2020 02:14 AM
    2 Attachment(s)
    • 2
    • 332
    Glenn Kennedy
    12-11-2020, 09:17 AM Go to last post

  18. [SOLVED] Formula for sum in different sheet

    Started by deromeo86‎, 12-11-2020 08:54 AM
    • 3
    • 228
    Pete_UK
    12-11-2020, 09:13 AM Go to last post

  19. [SOLVED] Formula/VBA to Vlookup multiple values both horizontally and vertically

    Started by sx200n‎, 11-17-2020 01:17 PM
    lookup 2 Attachment(s)
    • 4
    • 545
    Limor_OP
    12-11-2020, 07:51 AM Go to last post

  20. Update Hyperlinks

    Started by ANASBENM‎, 12-11-2020 06:14 AM
    • 5
    • 247
    AliGW
    12-11-2020, 07:02 AM Go to last post

  21. [SOLVED] What is the formula for summing up the quantity?

    Started by rayhen‎, 12-06-2020 06:57 AM
    1 Attachment(s)
    • 4
    • 362
    rayhen
    12-11-2020, 03:12 AM Go to last post

  22. Formula to Pull Through Specific Data from one Table / Tab to another

    Started by splottoman‎, 12-11-2020 02:48 AM
    2 Attachment(s)
    • 1
    • 270
    bebo021999
    12-11-2020, 02:56 AM Go to last post

  23. [SOLVED] Extract sheet Names and detrrmine if Finalised

    Started by Howardc1001‎, 12-10-2020 11:04 PM
    2 Attachment(s)
    • 6
    • 357
    Howardc1001
    12-11-2020, 02:10 AM Go to last post

  24. [SOLVED] Getting the value from sub sheets

    Started by Ajay45822‎, 12-08-2020 01:04 PM
    2 Attachment(s)
    • 9
    • 335
    Ajay45822
    12-11-2020, 01:45 AM Go to last post

  25. [SOLVED] Tracking of Time cannot return results for overnight timing and SUMIFS of time.

    Started by joeltan‎, 12-10-2020 11:39 PM
    1 Attachment(s)
    • 4
    • 376
    joeltan
    12-11-2020, 01:06 AM Go to last post

  26. [SOLVED] Auto allocation, append next row if not able to allocate quantity

    Started by sunny281199‎, 12-05-2020 11:42 PM
    2 Attachment(s)
    • 5
    • 504
    JeteMc
    12-10-2020, 10:35 PM Go to last post

  27. Question [SOLVED] What formulas should I use to bring all the alternatives listed?

    Started by ricdamiani‎, 12-08-2020 08:14 AM
    6 Attachment(s)
    • 8
    • 571
    bebo021999
    12-10-2020, 09:59 PM Go to last post

  28. [SOLVED] Data validation for specific text and numbers

    Started by chaiyya345‎, 12-10-2020 08:47 PM
    1 Attachment(s)
    • 3
    • 427
    Pete_UK
    12-10-2020, 09:37 PM Go to last post

  29. Calculating PTO

    Started by dappedu‎, 12-07-2020 02:44 PM
    2 Attachment(s)
    • 6
    • 921
    bebo021999
    12-10-2020, 09:31 PM Go to last post

  30. [SOLVED] Subtract from one column until zero, then another, than another.

    Started by TomRet‎, 12-09-2020 03:37 PM
    2 Attachment(s)
    • 4
    • 2,609
    TomRet
    12-10-2020, 09:29 PM Go to last post

  31. [SOLVED] If/Match formula problem

    Started by lilsnoop‎, 12-10-2020 08:20 PM
    1 Attachment(s)
    • 3
    • 255
    Pete_UK
    12-10-2020, 09:19 PM Go to last post

  32. Numerology Gematria withbtwo words or more

    Started by Aydy‎, 05-17-2015 07:21 AM
    gematria, numerology, space
    • 5
    • 3,963
    JeteMc
    12-10-2020, 08:44 PM Go to last post

  33. Converting hours to 7.5hrs day

    Started by jankrulak‎, 12-02-2020 02:11 PM
    2 Attachment(s)
    • 5
    • 2,425
    JeteMc
    12-10-2020, 07:52 PM Go to last post

  34. average last 3 cells in a column that are not blank

    Started by hawkdaddy404‎, 12-10-2020 11:31 AM
    3 Attachment(s)
    • 6
    • 397
    wk9128
    12-10-2020, 06:48 PM Go to last post

  35. Another Lookup Problem

    Started by okibam‎, 12-10-2020 04:43 PM
    1 Attachment(s)
    • 3
    • 263
    Fluff13
    12-10-2020, 05:58 PM Go to last post

  36. [SOLVED] Auto populate cells based on a drop down list selection

    Started by Ronald Reagan‎, 12-09-2020 03:05 PM
    2 Attachment(s)
    • 6
    • 498
    Ronald Reagan
    12-10-2020, 05:14 PM Go to last post

  37. [SOLVED] Combinations equaling a sum: a new twist

    Started by Numerist‎, 12-04-2020 09:32 PM
    combinations, cribbage, equaling, sum, target 2 Attachment(s)
    • 11
    • 883
    Numerist
    12-10-2020, 05:04 PM Go to last post

  38. [SOLVED] Find the column number of the first instance of a column with data

    Started by Tamarissa‎, 12-09-2020 10:07 PM
    3 Attachment(s)
    • 6
    • 287
    Tamarissa
    12-10-2020, 04:36 PM Go to last post

  39. Post Formula that will an weighted average of exchange rate

    Started by kubicka‎, 12-06-2020 12:28 PM
    2 Attachment(s)
    • 6
    • 522
    JeteMc
    12-10-2020, 04:22 PM Go to last post

  40. Countif with 2 columns 1 criteria and no duplication

    Started by J2424‎, 12-07-2020 09:58 AM
    'n jmu9h79y, formula and functions
    • 5
    • 396
    CARACALLA
    12-10-2020, 03:00 PM Go to last post

  41. [SOLVED] =SUM Within a SQRT Formula

    Started by Treeman_JF‎, 12-10-2020 01:39 PM
    • 1
    • 234
    Pete_UK
    12-10-2020, 02:20 PM Go to last post

  42. Calculate commission against target

    Started by Abbylandmark‎, 12-10-2020 12:34 PM
    1 Attachment(s)
    • 6
    • 283
    Glenn Kennedy
    12-10-2020, 01:04 PM Go to last post

  43. [SOLVED] How to highlight only immediate next cells with same value ?

    Started by jilaba‎, 12-10-2020 07:37 AM
    2 Attachment(s)
    • 2
    • 205
    jilaba
    12-10-2020, 01:02 PM Go to last post

  44. help Working out a Percentage (Lower the Number Higher the %)

    Started by techchrisdewey‎, 12-10-2020 12:41 PM
    excel
    • 2
    • 201
    etaf
    12-10-2020, 12:43 PM Go to last post

  45. Returning value in one sheet based on data and time criteria in another

    Started by bigagger‎, 12-10-2020 11:33 AM
    2 Attachment(s)
    • 2
    • 302
    Ochimus
    12-10-2020, 11:54 AM Go to last post

  46. Is there a function compiler?

    Started by danjackson5‎, 12-10-2020 06:23 AM
    • 3
    • 268
    MrShorty
    12-10-2020, 11:45 AM Go to last post

  47. Conditionally autofill the value of drop down lists

    Started by cjohnson092‎, 12-10-2020 11:06 AM
    autofill data, dropdown list 1 Attachment(s)
    • 1
    • 311
    Glenn Kennedy
    12-10-2020, 11:16 AM Go to last post

  48. [SOLVED] 85th Percentile Speed Survey

    Started by c.jones‎, 12-10-2020 08:53 AM
    4 Attachment(s)
    • 6
    • 1,739
    AliGW
    12-10-2020, 11:06 AM Go to last post

  49. [SOLVED] Average age of a group of years to 2020

    Started by Mythboy1‎, 12-10-2020 08:17 AM
    1 Attachment(s)
    • 5
    • 321
    AliGW
    12-10-2020, 11:03 AM Go to last post

  50. Look up a particular cell (that can be entered manually) and return the sheet(s) reference

    Started by ExcelNovice192‎, 12-10-2020 10:05 AM
    • 1
    • 279
    PaulM100
    12-10-2020, 10:48 AM Go to last post
+ Post New Thread
Page 592 of 5619 FirstFirst ... 592 ...

Forum Information and Options

Users Browsing this Forum

There are currently 65 users browsing this forum. (5 members & 60 guests)

  1. ExceLogan,
  2. Geo Jul,
  3. M S Narayanan,
  4. Marvi0518,
  5. 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