+ Post New Thread
Page 453 of 5614 FirstFirst ... 453 ...
Threads 22601 to 22650 of 280690

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

  1. [SOLVED] Help with #SPILL! error

    Started by BH1983‎, 07-28-2021 10:02 AM
    1 Attachment(s)
    • 6
    • 781
    wk9128
    07-28-2021, 07:49 PM Go to last post

  2. Lightbulb Help with sumifs to bring total by region and by deparment from different columns.

    Started by susanaolivo‎, 07-22-2021 02:38 PM
    2 Attachment(s)
    • 5
    • 260
    FlameRetired
    07-28-2021, 06:56 PM Go to last post

  3. [SOLVED] Combine two cell formula output results in a desired format

    Started by TINHAMMER‎, 07-28-2021 11:57 AM
    combine cells, format cell 6 Attachment(s)
    • 11
    • 503
    FlameRetired
    07-28-2021, 05:35 PM Go to last post

  4. Conditional Formatting not applying to all req'd cells

    Started by iCountWater‎, 04-23-2021 08:50 PM
    3 Attachment(s)
    • 3
    • 385
    iCountWater
    07-28-2021, 05:02 PM Go to last post

  5. Moved: Lot Number to Date...?

    Started by nickdclements‎, 07-28-2021 01:57 PM
    •  
    •  

  6. Nesting MID Function within =IF; Not able prevent excel from removing zero from formula

    Started by Stephen Buttle‎, 07-28-2021 01:56 PM
    2 Attachment(s)
    • 2
    • 192
    sohaila
    07-28-2021, 02:57 PM Go to last post

  7. Post Trying to do sumif for entire column automatically

    Started by hjmo‎, 07-28-2021 02:52 PM
    excel, sumif 2 Attachment(s)
    • 1
    • 320
    JohnTopley
    07-28-2021, 02:55 PM Go to last post

  8. [SOLVED] Inventory Tracking - Formula to find beginning inventory and ending inventory based

    Started by Prof Sick‎, 07-28-2021 01:44 PM
    beginning inventory, end inventory, inventory 1 Attachment(s)
    • 2
    • 397
    Prof Sick
    07-28-2021, 02:11 PM Go to last post

  9. [SOLVED] Formula to remove all characters after a specific character

    Started by rrcrossman‎, 07-28-2021 01:09 PM
    • 3
    • 202
    TMS
    07-28-2021, 02:09 PM Go to last post

  10. [SOLVED] Change columns but not rows, when pulling down formula

    Started by therealaccountant‎, 07-28-2021 01:43 PM
    1 Attachment(s)
    • 3
    • 660
    therealaccountant
    07-28-2021, 01:57 PM Go to last post

  11. [SOLVED] formula to return true if values are opposite and Equal in Col H

    Started by Howardc1001‎, 07-27-2021 10:59 AM
    2 Attachment(s)
    • 6
    • 308
    Pete_UK
    07-28-2021, 01:28 PM Go to last post

  12. Counting text in one column where a certain word exists in another

    Started by soph2083‎, 07-28-2021 11:57 AM
    • 1
    • 181
    AliGW
    07-28-2021, 12:04 PM Go to last post

  13. excel formulas to return the most common value depending on a criteria

    Started by Carmen Stan‎, 04-30-2015 08:27 AM
    • 7
    • 6,965
    Andrea Diskin
    07-28-2021, 11:38 AM Go to last post

  14. Question How to grab a number adjacent to a call containing searched text?

    Started by Zeayo2‎, 07-28-2021 10:39 AM
    1 Attachment(s)
    • 5
    • 318
    Pete_UK
    07-28-2021, 11:25 AM Go to last post

  15. Unique Values with Criteria

    Started by jharvey87‎, 07-28-2021 10:24 AM
    2 Attachment(s)
    • 7
    • 311
    AliGW
    07-28-2021, 10:34 AM Go to last post

  16. [SOLVED] Find the next date in a range based on criteria

    Started by FredJPerry‎, 07-28-2021 09:12 AM
    1 Attachment(s)
    • 4
    • 726
    AliGW
    07-28-2021, 10:24 AM Go to last post

  17. [SOLVED] VLOOKUP or Mixture of Index/Match to return a value

    Started by igotgame‎, 07-28-2021 12:59 AM
    1 Attachment(s)
    • 14
    • 326
    wk9128
    07-28-2021, 09:52 AM Go to last post

  18. Question [SOLVED] If formula searching for text

    Started by AHLARKY‎, 07-27-2021 10:35 AM
    2 Attachment(s)
    • 9
    • 325
    wk9128
    07-28-2021, 09:22 AM Go to last post

  19. Matching names to postcode data

    Started by Chapel12‎, 07-28-2021 07:48 AM
    • 2
    • 200
    AliGW
    07-28-2021, 07:52 AM Go to last post

  20. Thumbs up Pulling Working Days from a range

    Started by danjackson5‎, 07-26-2021 11:52 AM
    4 Attachment(s)
    • 11
    • 391
    danjackson5
    07-28-2021, 07:23 AM Go to last post

  21. how to clear excel filters for mac computers

    Started by anita2017‎, 12-04-2019 01:28 PM
    • 2
    • 567
    craig.mck
    07-28-2021, 07:05 AM Go to last post

  22. [SOLVED] Formula to do number and extract values

    Started by bjnockle‎, 07-25-2021 09:09 AM
    3 Attachment(s)
    • 5
    • 286
    bjnockle
    07-28-2021, 07:04 AM Go to last post

  23. Question Grouping column data based on another column without repeats

    Started by jack.elvy‎, 07-28-2021 12:05 AM
    2 Attachment(s)
    • 2
    • 235
    josephteh
    07-28-2021, 06:44 AM Go to last post

  24. [SOLVED] Return a value for a date between multiple date ranges

    Started by Excel_Fan2014‎, 07-28-2021 06:07 AM
    1 Attachment(s)
    • 4
    • 220
    JohnTopley
    07-28-2021, 06:35 AM Go to last post

  25. Trying to do everything in one cell, array (?)

    Started by diego7878‎, 07-27-2021 05:13 PM
    1 Attachment(s)
    • 3
    • 238
    kvsrinivasamurthy
    07-28-2021, 06:29 AM Go to last post

  26. XLOOKUP not working as well with sharepoint files

    Started by twaccess‎, 07-28-2021 05:31 AM
    • 0
    • 1,179
    twaccess
    07-28-2021, 05:31 AM Go to last post

  27. [SOLVED] Using the IFERROR function

    Started by BH1983‎, 07-28-2021 03:11 AM
    • 3
    • 262
    AliGW
    07-28-2021, 03:24 AM Go to last post

  28. Attendance Tracker: Variables & Counting Consecutive Days Worked with Reset

    Started by kramerc319‎, 07-27-2021 03:24 PM
    2 Attachment(s)
    • 5
    • 309
    JohnTopley
    07-28-2021, 02:32 AM Go to last post

  29. Calculating eligibility based on date

    Started by Andreas_Zopo‎, 07-27-2021 03:38 PM
    1 Attachment(s)
    • 5
    • 2,034
    JohnTopley
    07-28-2021, 12:41 AM Go to last post

  30. IF statement data validation

    Started by echoz‎, 07-27-2021 02:09 PM
    • 4
    • 264
    AliGW
    07-28-2021, 12:28 AM Go to last post

  31. Move data from one sheet to another when conditions are met

    Started by Shadd_wastaken‎, 07-27-2021 08:05 PM
    1 Attachment(s)
    • 1
    • 248
    6StringJazzer
    07-27-2021, 09:17 PM Go to last post

  32. [SOLVED] sum multiple sheets for multiple cells

    Started by madhatter40‎, 07-27-2021 02:16 PM
    2 Attachment(s)
    • 2
    • 323
    wk9128
    07-27-2021, 07:24 PM Go to last post

  33. [SOLVED] Generating next number

    Started by Lcarter114‎, 07-25-2021 06:36 PM
    1 Attachment(s)
    • 8
    • 306
    wk9128
    07-27-2021, 07:15 PM Go to last post

  34. [SOLVED] How to get less than or equal to the amount according to two criteria

    Started by rayhen‎, 07-25-2021 02:01 AM
    1 Attachment(s)
    • 5
    • 410
    wk9128
    07-27-2021, 07:03 PM Go to last post

  35. [SOLVED] Need last day of month returned by formula when only month name and year is known

    Started by kyle4570‎, 07-27-2021 05:35 PM
    1 Attachment(s)
    • 3
    • 222
    TMS
    07-27-2021, 06:28 PM Go to last post

  36. Formula to return the name of a color based on criteria

    Started by bmontoni‎, 07-27-2021 03:40 PM
    formula, if statement
    • 1
    • 307
    AliGW
    07-27-2021, 03:51 PM Go to last post

  37. [SOLVED] If then statement with Great than and less than

    Started by Ron Purpura‎, 07-27-2021 02:21 PM
    1 Attachment(s)
    • 3
    • 247
    Pete_UK
    07-27-2021, 02:54 PM Go to last post

  38. [SOLVED] Vlookup - Can't figure it out

    Started by LilyN‎, 07-27-2021 11:57 AM
    2 Attachment(s)
    • 5
    • 249
    bird333
    07-27-2021, 02:47 PM Go to last post

  39. Question Calculating multiple averages over a big sample without repeating used cells.

    Started by Charith_111‎, 07-23-2021 08:41 AM
    2 Attachment(s)
    • 9
    • 296
    JeteMc
    07-27-2021, 02:36 PM Go to last post

  40. Matching and relacing links

    Started by Kryos‎, 07-27-2021 01:57 PM
    1 Attachment(s)
    • 1
    • 155
    cubangt
    07-27-2021, 02:28 PM Go to last post

  41. Two-step, two-factor lookup and calculation

    Started by jschools‎, 07-27-2021 01:36 PM
    formula, help!!!, two-factor sum if
    • 1
    • 238
    alansidman
    07-27-2021, 02:05 PM Go to last post

  42. Appraisal Spreadsheet- Time of Sale Adjustment based on annual rate of change

    Started by 6string‎, 01-08-2019 08:41 AM
    • 3
    • 4,433
    alansidman
    07-27-2021, 01:19 PM Go to last post

  43. [SOLVED] How to use FILTER on two columns?

    Started by rubsley‎, 07-22-2021 12:13 PM
    4 Attachment(s)
    • 16
    • 371
    AliGW
    07-27-2021, 11:32 AM Go to last post

  44. Count and Number The Amount of Times That a Unique Value Appears in Increments of One

    Started by mtob‎, 07-27-2021 10:04 AM
    count, distinct, duplicate, numerical order, unique 1 Attachment(s)
    • 3
    • 402
    Pete_UK
    07-27-2021, 10:41 AM Go to last post

  45. [SOLVED] Calculate Across multiple Rows Depending on Column Content - end Result Date

    Started by Tybudd‎, 07-21-2021 03:04 PM
    3 Attachment(s)
    • 7
    • 383
    JeteMc
    07-27-2021, 10:11 AM Go to last post

  46. How to revert cell value from previous column based on search

    Started by martin_sushi‎, 07-27-2021 09:00 AM
    2 Attachment(s)
    • 2
    • 191
    martin_sushi
    07-27-2021, 10:05 AM Go to last post

  47. Find column of last valid number in a row

    Started by broadsword1‎, 07-27-2021 09:23 AM
    2 Attachment(s)
    • 4
    • 181
    Czeslaw
    07-27-2021, 09:56 AM Go to last post

  48. Get the total for a fiscal year

    Started by chaliseyp‎, 07-27-2021 07:23 AM
    2 Attachment(s)
    • 3
    • 198
    josephteh
    07-27-2021, 09:33 AM Go to last post

  49. Correlate 2 metrics

    Started by Rick Ratzlaff‎, 07-25-2021 08:18 PM
    • 3
    • 221
    janmorris
    07-27-2021, 09:31 AM Go to last post

  50. find column of last valid value in a row

    Started by broadsword1‎, 07-27-2021 08:46 AM
    • 2
    • 191
    AliGW
    07-27-2021, 09:30 AM Go to last post
+ Post New Thread
Page 453 of 5614 FirstFirst ... 453 ...

Forum Information and Options

Users Browsing this Forum

There are currently 53 users browsing this forum. (3 members & 50 guests)

  1. Czeslaw,
  2. JN831,
  3. 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