+ Post New Thread
Page 111 of 5614 FirstFirst ... 111 ...
Threads 5501 to 5550 of 280684

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

  1. Transposing Complex Data into Usable Format

    Started by craigc0187‎, 03-20-2022 03:42 PM
    formula, transpose array, transpose row to column 7 Attachment(s)
    • 19
    • 611
    craigc0187
    03-21-2022, 07:15 AM Go to last post

  2. Issue IF, SUM, ...

    Started by Bram84‎, 04-15-2017 02:23 PM
    5 Attachment(s)
    • 19
    • 576
    sandy666
    04-16-2017, 08:40 AM Go to last post

  3. [SOLVED] 2 criteria matched formula

    Started by AaruJaan‎, 11-02-2018 05:40 PM
    if formula excel, max and min 6 Attachment(s)
    • 19
    • 792
    Dumy
    11-04-2018, 07:05 AM Go to last post

  4. [SOLVED] Lookup a sheet up starting with name "..."

    Started by Odair‎, 11-13-2018 06:42 AM
    3 Attachment(s)
    • 19
    • 494
    Richard Buttrey
    11-13-2018, 01:52 PM Go to last post

  5. Substracting untill value is reached, starting from highest rank onwards

    Started by Hankdebever‎, 11-23-2018 12:16 PM
    5 Attachment(s)
    • 19
    • 613
    Hankdebever
    12-04-2018, 04:02 AM Go to last post

  6. [SOLVED] Tring to use Index Match but dont know how to solve the last part

    Started by frapi060‎, 12-12-2018 08:07 AM
    8 Attachment(s)
    • 19
    • 509
    Glenn Kennedy
    12-12-2018, 12:38 PM Go to last post

  7. formula paste values

    Started by max_max‎, 12-22-2018 12:37 PM
    6 Attachment(s)
    • 19
    • 693
    canapone
    12-23-2018, 05:25 AM Go to last post

  8. How to sort room schedule data automatically for a VLOOKUP

    Started by Force Flow‎, 01-10-2019 10:39 AM
    9 Attachment(s)
    • 19
    • 1,139
    dflak
    01-14-2019, 05:05 PM Go to last post

  9. Count Function Help

    Started by bowlerjp‎, 02-09-2019 06:43 AM
    4 Attachment(s)
    • 19
    • 465
    bowlerjp
    02-09-2019, 12:54 PM Go to last post

  10. [SOLVED] Golf League Hcp calculation

    Started by cjaiz71‎, 02-16-2019 06:27 PM
    average, golf 6 Attachment(s)
    • 19
    • 1,458
    cjaiz71
    02-17-2019, 04:37 PM Go to last post

  11. Red face Combining multiple cells to one with specific rules

    Started by AydanAr‎, 02-27-2019 12:01 PM
    8 Attachment(s)
    • 19
    • 487
    AydanAr
    03-16-2019, 07:47 PM Go to last post

  12. Question [SOLVED] Formula with multiples if statements

    Started by Gensigo‎, 03-04-2019 06:16 PM
    2 Attachment(s)
    • 19
    • 487
    MarvinP
    03-04-2019, 09:23 PM Go to last post

  13. [SOLVED] Xlookup when both the lookup value and lookup array are separated by commas

    Started by Eades1412‎, 02-07-2022 03:05 AM
    4 Attachment(s)
    • 19
    • 502
    AliGW
    02-08-2022, 04:49 AM Go to last post

  14. Calculating a minimum price based on variables

    Started by pafranklin‎, 03-24-2017 01:34 PM
    8 Attachment(s)
    • 19
    • 979
    pafranklin
    03-28-2017, 12:20 PM Go to last post

  15. [SOLVED] analysis of name combinations

    Started by billybob1731234‎, 12-23-2021 06:28 PM
    10 Attachment(s)
    • 19
    • 482
    billybob1731234
    12-25-2021, 11:35 AM Go to last post

  16. [SOLVED] Formula to count max number of simultaneous events

    Started by wazza121990‎, 02-02-2022 06:06 AM
    5 Attachment(s)
    • 19
    • 964
    AliGW
    09-20-2022, 09:27 AM Go to last post

  17. [SOLVED] Get the final date free after blockout

    Started by alferd324‎, 03-24-2022 05:16 AM
    4 Attachment(s)
    • 19
    • 318
    alferd324
    03-24-2022, 10:38 PM Go to last post

  18. [SOLVED] Trying to categorize using XLOOKUP without spaces in between

    Started by MitchMitchell‎, 03-07-2022 09:17 PM
    3 Attachment(s)
    • 19
    • 315
    wk9128
    03-07-2022, 11:26 PM Go to last post

  19. complex formula to filter data from one particular column

    Started by minszki‎, 03-16-2022 09:02 AM
    5 Attachment(s)
    • 19
    • 338
    Gregb11
    03-17-2022, 06:57 AM Go to last post

  20. [SOLVED] Count of Cell Highlighting over Multiple Columns per Name

    Started by MacClaus‎, 07-19-2022 12:06 PM
    2 Attachment(s)
    • 19
    • 348
    AliGW
    07-20-2022, 12:37 AM Go to last post

  21. Removing duplicates and counting

    Started by synergy80‎, 07-27-2022 10:05 PM
    6 Attachment(s)
    • 19
    • 517
    wk9128
    07-28-2022, 08:57 PM Go to last post

  22. setting auto date in cell

    Started by excelmaxel‎, 08-19-2022 01:33 AM
    5 Attachment(s)
    • 19
    • 370
    excelmaxel
    08-21-2022, 09:59 PM Go to last post

  23. [SOLVED] Pull/turn static values into a dynamic array without using offset

    Started by hullez‎, 08-27-2022 01:31 AM
    6 Attachment(s)
    • 19
    • 579
    hullez
    08-28-2022, 12:47 PM Go to last post

  24. Formulate unorganised data into organised one

    Started by idealist87‎, 10-13-2022 04:05 AM
    9 Attachment(s)
    • 19
    • 695
    TMS
    10-21-2022, 07:51 PM Go to last post

  25. Add word OR between the two words

    Started by goodboy‎, 10-18-2022 06:17 AM
    9 Attachment(s)
    • 19
    • 451
    Glenn Kennedy
    10-18-2022, 01:23 PM Go to last post

  26. [SOLVED] Date between and formula

    Started by Mimms‎, 09-08-2013 07:40 AM
    • 19
    • 1,554
    Mimms
    09-08-2013, 02:12 PM Go to last post

  27. Function/ formula to output a cell reference

    Started by Creator‎, 02-16-2006 01:50 PM
    • 19
    • 16,889
    Sandy Mann
    02-17-2006, 05:30 PM Go to last post

  28. Counting # of Times an Item Shows Up in a Table

    Started by Ralph‎, 12-17-2005 02:00 PM
    • 19
    • 1,571
    Aladin Akyurek
    12-18-2005, 10:30 AM Go to last post

  29. [SOLVED] How do I calculate if a date is in a certain time frame?

    Started by Pe66les‎, 08-26-2005 11:05 PM
    • 19
    • 2,178
    Ron Rosenfeld
    08-27-2005, 07:05 PM Go to last post

  30. Display Title for a Match found in a table

    Started by tsatsos007‎, 11-29-2007 11:06 AM
    6 Attachment(s)
    • 19
    • 1,511
    EdMac
    12-05-2007, 11:22 AM Go to last post

  31. Vlookup and Average

    Started by bpaw‎, 01-26-2008 02:41 AM
    3 Attachment(s)
    • 19
    • 2,627
    oldchippy
    01-26-2008, 02:57 PM Go to last post

  32. SUMPRODUCT formula not adding correctly

    Started by ExcelNewby‎, 02-10-2008 08:02 AM
    4 Attachment(s)
    • 19
    • 1,532
    ExcelNewby
    02-10-2008, 08:41 PM Go to last post

  33. Auto updates not working in Inputs

    Started by sunplum‎, 11-12-2012 07:34 PM
    2 Attachment(s)
    • 19
    • 860
    dredwolf
    11-16-2012, 07:57 PM Go to last post

  34. Counting how many times something occurs consecutively

    Started by hockeyadc‎, 11-15-2012 09:13 PM
    3 Attachment(s)
    • 19
    • 5,012
    dredwolf
    11-18-2012, 09:13 PM Go to last post

  35. [SOLVED] WHAT IF/IF Statement, multiply by &

    Started by Ianseconds‎, 12-11-2012 03:48 PM
    3 Attachment(s)
    • 19
    • 1,024
    JieJenn
    12-11-2012, 06:29 PM Go to last post

  36. Unhappy Enter number dependant on value in another cell

    Started by zhunter71‎, 12-24-2012 03:27 AM
    • 19
    • 1,440
    zhunter71
    01-03-2013, 03:28 AM Go to last post

  37. [SOLVED] Excessive Save times: Huge files + formulas

    Started by skorch‎, 01-11-2013 02:40 PM
    4 Attachment(s)
    • 19
    • 1,350
    FDibbins
    01-13-2013, 01:53 AM Go to last post

  38. Angry [SOLVED] Enter a value to change other cell values to match that throughout multiple worksheets

    Started by swiftworks‎, 01-14-2013 03:07 PM
    changing multiple values, conditional formatting, search 7 Attachment(s)
    • 19
    • 1,445
    dredwolf
    01-14-2013, 05:30 PM Go to last post

  39. Post Index Match Formula Help

    Started by kishoremcp‎, 03-27-2017 06:52 AM
    6 Attachment(s)
    • 19
    • 660
    vlady
    03-29-2017, 08:26 AM Go to last post

  40. [SOLVED] Separating the full name into First and Last name (and middle maybe) - is this possible?

    Started by benyben123‎, 09-12-2013 04:20 PM
    3 Attachment(s)
    • 19
    • 2,623
    mehmetcik
    09-13-2013, 03:17 PM Go to last post

  41. [SOLVED] Return month based on day of the year

    Started by Marco-Kun‎, 03-27-2014 10:02 AM
    • 19
    • 1,407
    AlKey
    03-27-2014, 11:58 AM Go to last post

  42. Formula to find the minimum value with constraint

    Started by LBala‎, 04-03-2014 11:47 PM
    1 Attachment(s)
    • 19
    • 2,205
    icestationzbra
    04-07-2014, 09:45 PM Go to last post

  43. Min of two sums if greater than one cell - help please

    Started by griffithsmaria‎, 05-22-2015 02:38 PM
    3 Attachment(s)
    • 19
    • 970
    griffithsmaria
    05-26-2015, 08:03 AM Go to last post

  44. Post Excel formula for calculating number of room nights

    Started by RAJIV5B‎, 06-01-2015 01:27 PM
    • 19
    • 7,672
    kvsrinivasamurthy
    01-02-2019, 01:11 PM Go to last post

  45. [SOLVED] Help with Conditional Formatting and Formula to put info on another page

    Started by Lowen‎, 07-13-2015 05:35 PM
    17 Attachment(s)
    • 19
    • 1,336
    JeteMc
    07-17-2015, 10:15 AM Go to last post

  46. Need help with an IF Average formula

    Started by kwoltman‎, 07-20-2015 03:54 PM
    1 Attachment(s)
    • 19
    • 1,090
    bhenlee
    07-20-2015, 05:52 PM Go to last post

  47. calculate time frames total without overlaps

    Started by happyhippo79‎, 12-16-2016 06:08 PM
    frames, overlaps, time 7 Attachment(s)
    • 19
    • 1,375
    Richard Buttrey
    01-29-2017, 06:58 AM Go to last post

  48. Looking for help manipulating data

    Started by john_berman‎, 03-08-2017 03:43 PM
    10 Attachment(s)
    • 19
    • 471
    john_berman
    03-09-2017, 07:03 PM Go to last post

  49. [SOLVED] Search Column A from top to bottom Countif

    Started by ricklou‎, 03-17-2017 04:28 AM
    5 Attachment(s)
    • 19
    • 886
    sanram
    03-17-2017, 09:36 AM Go to last post

  50. Match 3 Criteria and Return Lowest Numeric Value

    Started by Sam via OfficeKB.com‎, 04-03-2006 11:58 AM
    • 19
    • 2,486
    un1ty
    11-27-2012, 06:38 AM Go to last post
+ Post New Thread
Page 111 of 5614 FirstFirst ... 111 ...

Forum Information and Options

Users Browsing this Forum

There are currently 64 users browsing this forum. (3 members & 61 guests)

  1. cwwazy,
  2. DeeWuu,
  3. positivemind

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