+ Post New Thread
Page 502 of 5614 FirstFirst ... 502 ...
Threads 25051 to 25100 of 280678

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

  1. Extract date from string

    Started by acandan21‎, 04-29-2021 02:20 PM
    • 3
    • 236
    Fluff13
    04-29-2021, 04:46 PM Go to last post

  2. [SOLVED] COUNTIF not listed in A2:A79

    Started by jmcole‎, 04-29-2021 01:15 PM
    2 Attachment(s)
    • 7
    • 272
    6StringJazzer
    04-29-2021, 04:28 PM Go to last post

  3. Move all text containing ABC to Cell A1 separated by ,

    Started by rolive‎, 04-29-2021 02:47 PM
    commas
    • 7
    • 271
    Fluff13
    04-29-2021, 03:34 PM Go to last post

  4. Substitute text in a string if it matches a value in a table

    Started by carolinahusker‎, 04-29-2021 01:45 PM
    2 Attachment(s)
    • 3
    • 183
    JohnTopley
    04-29-2021, 02:50 PM Go to last post

  5. [SOLVED] Drop Down with YES choice but Changes to a check Mark

    Started by tacnola‎, 04-29-2021 09:45 AM
    2 Attachment(s)
    • 7
    • 234
    tacnola
    04-29-2021, 02:19 PM Go to last post

  6. Need formula for Bid Bond Calculation

    Started by electricguy57104‎, 04-29-2021 12:50 PM
    bid bond, formula 1 Attachment(s)
    • 5
    • 547
    MrShorty
    04-29-2021, 02:16 PM Go to last post

  7. IF/THEN on Blood Collection Times Post COVID-19 Test Using Date/Time

    Started by Amy EH‎, 04-29-2021 01:51 PM
    date & time calculation, hour calculation, nested formula
    • 1
    • 268
    FlameRetired
    04-29-2021, 02:03 PM Go to last post

  8. [SOLVED] Formula for same value in cell on different sheet

    Started by dodde‎, 04-28-2021 05:18 AM
    1 Attachment(s)
    • 13
    • 424
    dodde
    04-29-2021, 01:51 PM Go to last post

  9. [SOLVED] Need to populate counts from multiple workbooks into main report based on month

    Started by cubangt‎, 04-29-2021 09:41 AM
    5 Attachment(s)
    • 10
    • 294
    cubangt
    04-29-2021, 01:42 PM Go to last post

  10. Two criteria, return "1"

    Started by Calc7827‎, 04-28-2021 05:20 PM
    • 5
    • 243
    etaf
    04-29-2021, 12:39 PM Go to last post

  11. [SOLVED] INDEX and MATCH Formula Error

    Started by VijayJangam‎, 04-12-2021 07:36 AM
    3 Attachment(s)
    • 12
    • 408
    VijayJangam
    04-29-2021, 12:34 PM Go to last post

  12. [SOLVED] Create new sentence after "Good Morning James"

    Started by Howardc1001‎, 04-29-2021 11:18 AM
    1 Attachment(s)
    • 2
    • 335
    Howardc1001
    04-29-2021, 12:03 PM Go to last post

  13. Question [SOLVED] Need a formula to subtract 1 from another cell depending on the text input in another cell

    Started by SoheebHussain‎, 04-29-2021 11:12 AM
    automatically change, change a cell value, dropdown list excel, formula and functions, subtract if 1 Attachment(s)
    • 3
    • 466
    Pete_UK
    04-29-2021, 11:31 AM Go to last post

  14. Pay Scale with bonuses

    Started by raymondcg‎, 04-29-2021 09:42 AM
    1 Attachment(s)
    • 2
    • 209
    raymondcg
    04-29-2021, 11:30 AM Go to last post

  15. Question Average non-continuous cells if not '0'

    Started by g_teacher_1848‎, 04-29-2021 06:27 AM
    average, formula 5 Attachment(s)
    • 12
    • 614
    Pete_UK
    04-29-2021, 11:11 AM Go to last post

  16. Counting values in one column based on the value in another column

    Started by BH1983‎, 04-29-2021 10:50 AM
    1 Attachment(s)
    • 2
    • 202
    BH1983
    04-29-2021, 11:01 AM Go to last post

  17. [SOLVED] A lookup table that varies according to the row of the lookup.

    Started by Osprey2‎, 04-28-2021 10:25 AM
    1 Attachment(s)
    • 6
    • 261
    phatdear
    04-29-2021, 10:50 AM Go to last post

  18. Modify formula and conditional formatting

    Started by GPetcu‎, 04-29-2021 05:43 AM
    2 Attachment(s)
    • 6
    • 228
    kvsrinivasamurthy
    04-29-2021, 10:24 AM Go to last post

  19. [SOLVED] Exact month to see when I break even

    Started by francioku‎, 04-29-2021 09:11 AM
    1 Attachment(s)
    • 2
    • 619
    francioku
    04-29-2021, 10:17 AM Go to last post

  20. [SOLVED] Return filepath/name only to a cell

    Started by shaunda101‎, 04-28-2021 11:33 AM
    file path, hyperlink
    • 2
    • 423
    shaunda101
    04-29-2021, 10:02 AM Go to last post

  21. Tiered pricing for vehicle rental using SUMPRODUCT

    Started by ouboss‎, 04-29-2021 06:05 AM
    • 6
    • 259
    JohnTopley
    04-29-2021, 09:42 AM Go to last post

  22. Trying to create a rating system based on certain criteria

    Started by tmiller85‎, 04-28-2021 02:07 PM
    3 Attachment(s)
    • 8
    • 308
    Bernie Deitrick
    04-29-2021, 09:34 AM Go to last post

  23. [SOLVED] Automatically copy date reference if there is a 1 in the table corresponding to it

    Started by JulianS96‎, 04-29-2021 07:46 AM
    2 Attachment(s)
    • 2
    • 200
    JulianS96
    04-29-2021, 08:57 AM Go to last post

  24. [SOLVED] Pivot chart issue

    Started by Andrea Maccaferri‎, 04-29-2021 06:51 AM
    1 Attachment(s)
    • 6
    • 220
    rorya
    04-29-2021, 08:46 AM Go to last post

  25. [SOLVED] Sumproduct with dates

    Started by DEEARO‎, 04-29-2021 07:54 AM
    3 Attachment(s)
    • 2
    • 229
    Czeslaw
    04-29-2021, 08:35 AM Go to last post

  26. [SOLVED] Prevent Double Quotes in formula

    Started by NewYears1978‎, 04-28-2021 01:45 PM
    • 3
    • 286
    6StringJazzer
    04-29-2021, 07:39 AM Go to last post

  27. how to sum formula to get total value from another column times with another column

    Started by leakhna‎, 04-29-2021 06:58 AM
    2 Attachment(s)
    • 1
    • 168
    Bo_Ry
    04-29-2021, 07:03 AM Go to last post

  28. [SOLVED] Convert data to hh:mm:ss

    Started by JacobH123‎, 04-29-2021 05:53 AM
    1 Attachment(s)
    • 3
    • 509
    Pete_UK
    04-29-2021, 06:36 AM Go to last post

  29. Normalize rows to highest value

    Started by Phero100‎, 04-29-2021 04:56 AM
    2 Attachment(s)
    • 3
    • 274
    JohnTopley
    04-29-2021, 05:40 AM Go to last post

  30. [SOLVED] Column number of nth Text

    Started by minhys1‎, 04-24-2021 10:53 PM
    2 Attachment(s)
    • 7
    • 398
    kvsrinivasamurthy
    04-29-2021, 04:57 AM Go to last post

  31. Question [SOLVED] MATCH AND INDEX FUNCTION RETURNS #NA (Value not available error)

    Started by fkraval_07‎, 04-29-2021 03:37 AM
    index + match 1 Attachment(s)
    • 2
    • 403
    fkraval_07
    04-29-2021, 04:45 AM Go to last post

  32. [SOLVED] Sum question with specific criteria

    Started by Jaded724‎, 04-28-2021 05:57 PM
    4 Attachment(s)
    • 8
    • 387
    Richard Buttrey
    04-29-2021, 04:44 AM Go to last post

  33. [SOLVED] Change currency in quotation (automatically if an certain currency is selected.

    Started by The excel apprentice‎, 04-04-2016 09:12 AM
    currency, currency converter 1 Attachment(s)
    • 12
    • 1,786
    JohnTopley
    04-29-2021, 03:31 AM Go to last post

  34. Excel keeps calculating - no idea why?

    Started by martmass‎, 04-22-2021 03:00 PM
    7 Attachment(s)
    • 16
    • 582
    Pepe Le Mokko
    04-29-2021, 02:10 AM Go to last post

  35. [SOLVED] Multiple Calculations Formula Required

    Started by DanRichards0n‎, 04-28-2021 02:04 PM
    3 Attachment(s)
    • 7
    • 263
    JohnTopley
    04-29-2021, 01:35 AM Go to last post

  36. [SOLVED] Help with lookup formula

    Started by dalewms3‎, 04-28-2021 09:57 PM
    1 Attachment(s)
    • 1
    • 180
    AliGW
    04-29-2021, 12:55 AM Go to last post

  37. Question Sumif with multiple criteria and multiple sumrange

    Started by GoldenChicken‎, 04-28-2021 11:06 PM
    1 Attachment(s)
    • 1
    • 260
    JohnTopley
    04-29-2021, 12:47 AM Go to last post

  38. why isnt this working

    Started by vern07‎, 04-24-2021 08:39 PM
    1 Attachment(s)
    • 3
    • 302
    vern07
    04-28-2021, 09:58 PM Go to last post

  39. how to hide amounts on incomplete formulae?

    Started by Browne‎, 04-28-2021 05:28 PM
    • 1
    • 269
    Pete_UK
    04-28-2021, 08:43 PM Go to last post

  40. Autopopulating a table using a dropdown and data from another table

    Started by Shazaam41‎, 04-27-2021 09:30 PM
    4 Attachment(s)
    • 7
    • 347
    Shazaam41
    04-28-2021, 08:16 PM Go to last post

  41. [SOLVED] Function to coverts all specific numbers in a cell to 1 and 2 numeric values

    Started by Karnik‎, 04-27-2021 09:10 AM
    3 Attachment(s)
    • 9
    • 466
    FlameRetired
    04-28-2021, 05:47 PM Go to last post

  42. [SOLVED] Tracking order dates.

    Started by pavlosm‎, 04-28-2021 03:54 PM
    2 Attachment(s)
    • 2
    • 320
    pavlosm
    04-28-2021, 05:00 PM Go to last post

  43. [SOLVED] Get Date from Year, Week Number, and Weekday

    Started by KingLudovic‎, 04-28-2021 03:06 PM
    2 Attachment(s)
    • 3
    • 214
    6StringJazzer
    04-28-2021, 04:56 PM Go to last post

  44. Organising oxygen records

    Started by Onebreath‎, 04-28-2021 02:54 PM
    2 Attachment(s)
    • 1
    • 198
    Richard Buttrey
    04-28-2021, 04:33 PM Go to last post

  45. Arrow Convert Daily Data to Monthly Data

    Started by JohnArrow21‎, 04-28-2021 02:35 PM
    2 Attachment(s)
    • 6
    • 271
    The_Snook
    04-28-2021, 03:48 PM Go to last post

  46. Need Help with a Formula to add and subtract

    Started by laranoelle‎, 04-28-2021 03:15 PM
    1 Attachment(s)
    • 4
    • 224
    Fluff13
    04-28-2021, 03:32 PM Go to last post

  47. Create Averages

    Started by alandavies‎, 04-28-2021 03:01 PM
    1 Attachment(s)
    • 5
    • 268
    cubangt
    04-28-2021, 03:16 PM Go to last post

  48. [SOLVED] Count If help with Unique Dates

    Started by Bergentrude1‎, 04-28-2021 09:36 AM
    1 Attachment(s)
    • 9
    • 248
    JohnTopley
    04-28-2021, 03:15 PM Go to last post

  49. COUNTIF Question

    Started by fathafluff‎, 04-28-2021 02:50 PM
    1 Attachment(s)
    • 2
    • 226
    TMS
    04-28-2021, 03:13 PM Go to last post

  50. [SOLVED] Find all unique values that are not blank

    Started by Tjfinley‎, 04-28-2021 02:44 PM
    1 Attachment(s)
    • 3
    • 177
    Fluff13
    04-28-2021, 03:02 PM Go to last post
+ Post New Thread
Page 502 of 5614 FirstFirst ... 502 ...

Forum Information and Options

Users Browsing this Forum

There are currently 90 users browsing this forum. (6 members & 84 guests)

  1. cwwazy,
  2. Danilo Flaiban,
  3. Ravana,
  4. RechBR,
  5. tungten9x

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