+ Post New Thread
Page 398 of 5619 FirstFirst ... 398 ...
Threads 19851 to 19900 of 280939

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

  1. Need help fixing vlookup formula or formatting

    Started by dlittle4‎, 11-24-2021 03:54 PM
    • 6
    • 288
    Richard Buttrey
    11-24-2021, 06:33 PM Go to last post

  2. Index and match ?

    Started by Ron Purpura‎, 11-24-2021 04:20 PM
    3 Attachment(s)
    • 4
    • 243
    Ron Purpura
    11-24-2021, 05:42 PM Go to last post

  3. ACS11 to Hex conversion Formula

    Started by Btape‎, 11-23-2021 04:12 PM
    • 21
    • 501
    Fluff13
    11-24-2021, 05:02 PM Go to last post

  4. [SOLVED] extract alert name from a dynamic changing string

    Started by esaji‎, 11-24-2021 10:09 AM
    2 Attachment(s)
    • 12
    • 356
    JohnTopley
    11-24-2021, 05:01 PM Go to last post

  5. Replace sumproduct with sumifs

    Started by leprince2007‎, 11-24-2021 02:44 PM
    3 Attachment(s)
    • 7
    • 331
    DJunqueira
    11-24-2021, 04:45 PM Go to last post

  6. [SOLVED] Round Formula for decimals points. Facing Issue

    Started by techmaish‎, 03-31-2017 06:36 AM
    3 Attachment(s)
    • 12
    • 1,040
    TK2013
    11-24-2021, 04:11 PM Go to last post

  7. [SOLVED] Using Formula(s) to Highlight Cells with Matching Values Across Workbooks

    Started by takktheimpaler‎, 11-24-2021 02:50 PM
    • 2
    • 167
    takktheimpaler
    11-24-2021, 03:54 PM Go to last post

  8. [SOLVED] Count of Yes and No in data

    Started by amitmodi_mrt‎, 11-24-2021 02:39 PM
    1 Attachment(s)
    • 4
    • 264
    Fluff13
    11-24-2021, 03:15 PM Go to last post

  9. Question [SOLVED] Modifying an IF formula to exclude fields with a certain criteria

    Started by spacelord69‎, 11-23-2021 11:18 AM
    exclude, formula, if formula 2 Attachment(s)
    • 4
    • 366
    spacelord69
    11-24-2021, 02:19 PM Go to last post

  10. [SOLVED] SUMIFS - to sum month data at a decreasing rate Nov-Sep, then Dec-Sept, Jan-Sep, HELP!

    Started by Aepenguins‎, 11-24-2021 12:07 PM
    can you solve this?, love sumif, please help 1 Attachment(s)
    • 4
    • 292
    Aepenguins
    11-24-2021, 02:18 PM Go to last post

  11. Can you use VLOOKUP to return value if conditions are met?

    Started by cubangt‎, 11-11-2021 12:29 PM
    13 Attachment(s)
    • 37
    • 728
    cubangt
    11-24-2021, 01:16 PM Go to last post

  12. Formatting cells shows wrong

    Started by KentaTippar‎, 11-24-2021 11:07 AM
    2 Attachment(s)
    • 4
    • 207
    KentaTippar
    11-24-2021, 12:46 PM Go to last post

  13. [SOLVED] formula help, to calculate the days onsite in a movement planner

    Started by Stephen Reeves‎, 11-03-2021 08:17 AM
    calulated fields, date count, date planner, formating 2 Attachment(s)
    • 11
    • 457
    Keebellah
    11-24-2021, 12:45 PM Go to last post

  14. Sumproduct Frequency, IF Match

    Started by DaveB0208‎, 11-24-2021 10:24 AM
    1 Attachment(s)
    • 5
    • 223
    WideBoyDixon
    11-24-2021, 12:44 PM Go to last post

  15. Exported report data into excel is visiually good but all numbers/values/dates are text

    Started by poorinexcel‎, 11-23-2021 06:19 PM
    text to value
    • 2
    • 212
    poorinexcel
    11-24-2021, 12:00 PM Go to last post

  16. Post [SOLVED] Add A Period To Cell If A Value, if not leave blank

    Started by gr8whthunter76‎, 11-24-2021 11:23 AM
    2 Attachment(s)
    • 6
    • 249
    gr8whthunter76
    11-24-2021, 11:49 AM Go to last post

  17. Vlookup with one return but filters multiple possibilities

    Started by timmymckinney‎, 11-24-2021 11:35 AM
    1 Attachment(s)
    • 1
    • 189
    Pepe Le Mokko
    11-24-2021, 11:42 AM Go to last post

  18. IF Function on multiple cells to display end text result

    Started by Lewnatic‎, 11-24-2021 10:39 AM
    1 Attachment(s)
    • 1
    • 227
    WideBoyDixon
    11-24-2021, 10:59 AM Go to last post

  19. Finding values across different columns and showing row value in specific column

    Started by hello123456789101112‎, 11-20-2021 03:09 AM
    2 Attachment(s)
    • 4
    • 308
    JeteMc
    11-24-2021, 10:56 AM Go to last post

  20. Conditional Formatting Headache

    Started by beastylad‎, 11-24-2021 08:43 AM
    1 Attachment(s)
    • 7
    • 214
    torachan
    11-24-2021, 10:21 AM Go to last post

  21. Formula to Insert Sheet Name in Excel doesnt work in Sharepoint

    Started by Rick Vu‎, 11-24-2021 10:12 AM
    • 2
    • 274
    Rick Vu
    11-24-2021, 10:18 AM Go to last post

  22. [SOLVED] Move data from one sheet to another which matches two criteria

    Started by tjdate‎, 10-24-2021 05:23 AM
    5 Attachment(s)
    • 24
    • 576
    JohnTopley
    11-24-2021, 09:23 AM Go to last post

  23. range from criteria

    Started by lemans96‎, 09-18-2021 09:27 AM
    5 Attachment(s)
    • 8
    • 350
    lemans96
    11-24-2021, 09:16 AM Go to last post

  24. [SOLVED] Can I add a 2nd criteria to VLookup

    Started by MwMarty‎, 11-21-2021 06:30 PM
    2 Attachment(s)
    • 4
    • 283
    WideBoyDixon
    11-24-2021, 09:04 AM Go to last post

  25. [SOLVED] How to fill in cell when the data is missing from one cell but you need it look backwards

    Started by y0urd00md‎, 11-23-2021 07:55 AM
    2 Attachment(s)
    • 4
    • 229
    y0urd00md
    11-24-2021, 06:41 AM Go to last post

  26. Sum column based on date range

    Started by DDriscoll‎, 11-24-2021 02:25 AM
    3 Attachment(s)
    • 4
    • 218
    DJunqueira
    11-24-2021, 06:22 AM Go to last post

  27. [SOLVED] Adding an array with an Offset

    Started by markvdhouten‎, 11-22-2021 12:53 PM
    4 Attachment(s)
    • 8
    • 660
    DJunqueira
    11-23-2021, 10:16 PM Go to last post

  28. [SOLVED] Dont use data if value is 0

    Started by susigan‎, 12-25-2020 02:31 PM
    9 Attachment(s)
    • 30
    • 1,006
    susigan
    11-23-2021, 09:09 PM Go to last post

  29. Excel formula to get numeric values from a row based on match from another row

    Started by docGee‎, 11-23-2021 07:52 PM
    1 Attachment(s)
    • 4
    • 184
    Estevaoba
    11-23-2021, 08:33 PM Go to last post

  30. [SOLVED] Sum total based on a date range

    Started by Justinmih‎, 11-18-2021 03:54 PM
    2 Attachment(s)
    • 5
    • 384
    JeteMc
    11-23-2021, 08:06 PM Go to last post

  31. Automatic Copy/Paste values?

    Started by TXT007‎, 11-23-2021 12:35 AM
    1 Attachment(s)
    • 4
    • 251
    TXT007
    11-23-2021, 07:20 PM Go to last post

  32. [SOLVED] Extract values from list based on a formula value from a different column

    Started by kwoltman‎, 11-23-2021 05:06 PM
    • 4
    • 264
    WideBoyDixon
    11-23-2021, 06:16 PM Go to last post

  33. Merging two sets of data

    Started by Fraistolf‎, 11-23-2021 05:18 PM
    • 1
    • 187
    janmorris
    11-23-2021, 05:54 PM Go to last post

  34. Return values if other cells meet criteria

    Started by dlhtox‎, 11-19-2021 01:50 PM
    3 Attachment(s)
    • 1
    • 267
    JeteMc
    11-23-2021, 05:34 PM Go to last post

  35. [SOLVED] Split string into alphanumerical expressions, extract numbers and assign to column

    Started by Noah14‎, 11-23-2021 01:53 PM
    3 Attachment(s)
    • 5
    • 459
    Noah14
    11-23-2021, 04:29 PM Go to last post

  36. Help with in and out times in Excel data

    Started by Bezzina‎, 11-23-2021 03:17 PM
    2 Attachment(s)
    • 4
    • 230
    JEC.
    11-23-2021, 04:28 PM Go to last post

  37. [SOLVED] find/lookup repeat data and count/calculate

    Started by Por2gal‎, 11-13-2021 04:14 PM
    2 Attachment(s)
    • 10
    • 384
    Por2gal
    11-23-2021, 03:54 PM Go to last post

  38. [SOLVED] Help with nested IF function

    Started by pradeepkodali‎, 11-23-2021 12:50 PM
    2 Attachment(s)
    • 4
    • 240
    pradeepkodali
    11-23-2021, 03:39 PM Go to last post

  39. [SOLVED] vlOOKUP right function

    Started by rayted‎, 11-23-2021 01:35 PM
    2 Attachment(s)
    • 2
    • 203
    rayted
    11-23-2021, 02:04 PM Go to last post

  40. [SOLVED] SUMIF and AVERAGEIF formulae not working

    Started by Ochimus‎, 11-23-2021 01:17 PM
    1 Attachment(s)
    • 3
    • 274
    Ochimus
    11-23-2021, 01:53 PM Go to last post

  41. Find Duplicate & List Addresses

    Started by Hyflex‎, 11-23-2021 10:19 AM
    1 Attachment(s)
    • 2
    • 221
    Hyflex
    11-23-2021, 01:38 PM Go to last post

  42. [SOLVED] Total sheet to add up multiple worksheets

    Started by Hiltsy‎, 11-23-2021 07:25 AM
    2 Attachment(s)
    • 9
    • 320
    Hiltsy
    11-23-2021, 12:40 PM Go to last post

  43. Returning data between two specified time stamps

    Started by wild0wess‎, 11-23-2021 11:53 AM
    1 Attachment(s)
    • 3
    • 161
    Pete_UK
    11-23-2021, 12:22 PM Go to last post

  44. Lookup info on a sheet with a counter

    Started by Sahara1899‎, 11-23-2021 11:38 AM
    • 2
    • 219
    Sahara1899
    11-23-2021, 11:58 AM Go to last post

  45. [SOLVED] Copy a cell defined as text either as value or text

    Started by mss90‎, 11-23-2021 08:20 AM
    • 3
    • 264
    Pete_UK
    11-23-2021, 11:52 AM Go to last post

  46. help with #value error

    Started by cimerio‎, 11-19-2021 02:12 PM
    3 Attachment(s)
    • 15
    • 390
    MikeAnhVu
    11-23-2021, 11:46 AM Go to last post

  47. [SOLVED] Count function including blank cells

    Started by kris01‎, 11-23-2021 09:49 AM
    1 Attachment(s)
    • 5
    • 294
    Fluff13
    11-23-2021, 11:21 AM Go to last post

  48. [SOLVED] Agency Spend Audit

    Started by Mike952‎, 11-22-2021 04:55 PM
    2 Attachment(s)
    • 3
    • 300
    Estevaoba
    11-23-2021, 11:13 AM Go to last post

  49. Lookup formula: bring back the closest number and convert it into a letter

    Started by CLAREC83‎, 11-23-2021 08:15 AM
    1 Attachment(s)
    • 3
    • 252
    AliGW
    11-23-2021, 08:43 AM Go to last post

  50. Red face Fixing Name problem

    Started by alamnew‎, 11-23-2021 07:29 AM
    • 4
    • 178
    davsth
    11-23-2021, 08:36 AM Go to last post
+ Post New Thread
Page 398 of 5619 FirstFirst ... 398 ...

Forum Information and Options

Users Browsing this Forum

There are currently 49 users browsing this forum. (1 members & 48 guests)

  1. sanith

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