+ Post New Thread
Page 351 of 5614 FirstFirst ... 351 ...
Threads 17501 to 17550 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. Question VLOOKUP Issues

    Started by jderosa3‎, 02-15-2022 10:54 AM
    large file, multiple column search, vlookup 4 Attachment(s)
    • 11
    • 510
    jderosa3
    02-15-2022, 03:43 PM Go to last post

  2. [SOLVED] Return the results of a formula after looking up a string of text

    Started by wendy823‎, 02-11-2022 12:50 PM
    4 Attachment(s)
    • 8
    • 387
    wendy823
    02-15-2022, 03:41 PM Go to last post

  3. Remove duplicate and sum

    Started by bob112233‎, 02-15-2022 02:18 AM
    3 Attachment(s)
    • 10
    • 1,772
    bob112233
    02-15-2022, 02:33 PM Go to last post

  4. Conditional Formatting Question Regarding Document Expiry Dates

    Started by LLSW54‎, 02-15-2022 11:24 AM
    • 4
    • 245
    Richard Buttrey
    02-15-2022, 02:15 PM Go to last post

  5. Use INDEX MATCH to find greater than/equal to value

    Started by Bobgiant‎, 02-07-2022 04:04 PM
    3 Attachment(s)
    • 6
    • 560
    Bobgiant
    02-15-2022, 01:08 PM Go to last post

  6. INDEX MATCH that compares if date is between two dates and returns yes or no

    Started by jjoseph08‎, 02-15-2022 12:44 PM
    2 Attachment(s)
    • 1
    • 185
    6StringJazzer
    02-15-2022, 01:07 PM Go to last post

  7. how can I insert a sheet and the formula change depending on sheet name automatically

    Started by Bobgiant‎, 02-14-2022 04:57 PM
    1 Attachment(s)
    • 3
    • 264
    ben8563
    02-15-2022, 01:06 PM Go to last post

  8. IF, AND, THEN formula help needed.

    Started by kjb123‎, 02-15-2022 12:35 PM
    2 Attachment(s)
    • 4
    • 265
    ben8563
    02-15-2022, 12:53 PM Go to last post

  9. [SOLVED] Trying to average a number across muttiple tabs in a workbook using =AVERAGEIF - Get ERROR

    Started by rgoins82‎, 02-14-2022 04:42 PM
    1 Attachment(s)
    • 5
    • 227
    XOR LX
    02-15-2022, 12:09 PM Go to last post

  10. [SOLVED] formula to return unique values for duplicate values in range

    Started by Rerock‎, 02-15-2022 08:53 AM
    3 Attachment(s)
    • 6
    • 296
    Rerock
    02-15-2022, 11:56 AM Go to last post

  11. [SOLVED] Need help with a formula - I cannot figure out what I have done wrong....

    Started by excel-dropout‎, 01-23-2022 08:10 PM
    • 7
    • 221
    AliGW
    02-15-2022, 11:23 AM Go to last post

  12. [SOLVED] Textjoin, Concat a list of emails if they are in a specific Group.

    Started by MinisoftEggshell‎, 02-15-2022 09:16 AM
    2 Attachment(s)
    • 4
    • 265
    AliGW
    02-15-2022, 10:41 AM Go to last post

  13. [SOLVED] Sort by drop down menu

    Started by Arismac74‎, 02-15-2022 09:40 AM
    drop down 1 Attachment(s)
    • 2
    • 282
    AliGW
    02-15-2022, 10:27 AM Go to last post

  14. Excel Formula that reads the cell value, not the formula in the cell

    Started by ksterling‎, 02-15-2022 09:58 AM
    1 Attachment(s)
    • 4
    • 237
    Glenn Kennedy
    02-15-2022, 10:13 AM Go to last post

  15. [SOLVED] Summing Data Based on Overlapping Multiple Criteria

    Started by TMains‎, 02-14-2022 04:24 PM
    2 Attachment(s)
    • 4
    • 241
    TMains
    02-15-2022, 10:04 AM Go to last post

  16. Conditional formatting with a difference

    Started by HeroAl‎, 01-28-2022 07:09 AM
    6 Attachment(s)
    • 14
    • 408
    HeroAl
    02-15-2022, 09:59 AM Go to last post

  17. Formula to return A ∩ C but exclude similar values of B

    Started by N0043‎, 02-15-2022 09:57 AM
    data adv. filter, excel, filter based on criteria, formula, google sheets
    • 1
    • 244
    Glenn Kennedy
    02-15-2022, 09:59 AM Go to last post

  18. [SOLVED] Get next day date

    Started by Undo‎, 02-15-2022 08:23 AM
    2 Attachment(s)
    • 3
    • 204
    AliGW
    02-15-2022, 09:10 AM Go to last post

  19. [SOLVED] How to automatically duplicate dates with different timing ?

    Started by Complus865‎, 02-15-2022 07:20 AM
    1 Attachment(s)
    • 3
    • 209
    AliGW
    02-15-2022, 08:41 AM Go to last post

  20. [SOLVED] Trying to work out the number of times a month appears within a given date range

    Started by chrisbus‎, 02-14-2022 02:16 PM
    3 Attachment(s)
    • 5
    • 273
    6StringJazzer
    02-15-2022, 08:34 AM Go to last post

  21. [SOLVED] can you ignore 0%s in a Colum using averageif

    Started by sharky1978‎, 02-15-2022 06:44 AM
    3 Attachment(s)
    • 6
    • 181
    AliGW
    02-15-2022, 07:40 AM Go to last post

  22. [SOLVED] Using tabs in formulas

    Started by TechnoRage‎, 02-15-2022 05:45 AM
    1 Attachment(s)
    • 4
    • 200
    AliGW
    02-15-2022, 06:58 AM Go to last post

  23. Formula to fatching the data with filter

    Started by Naveenaggarwal‎, 02-15-2022 04:55 AM
    2 Attachment(s)
    • 4
    • 186
    Glenn Kennedy
    02-15-2022, 05:48 AM Go to last post

  24. [SOLVED] Help with holiday calculation formula

    Started by 355858‎, 02-14-2022 11:59 AM
    holidays 2 Attachment(s)
    • 9
    • 349
    AliGW
    02-15-2022, 05:45 AM Go to last post

  25. [SOLVED] Index Match Randbetween returns #N/A

    Started by nossucram‎, 02-15-2022 04:17 AM
    2 Attachment(s)
    • 5
    • 657
    AliGW
    02-15-2022, 05:36 AM Go to last post

  26. Copy data from a master sheet

    Started by sMart_D1006‎, 02-15-2022 05:23 AM
    1 Attachment(s)
    • 1
    • 211
    AliGW
    02-15-2022, 05:26 AM Go to last post

  27. Solved if a specific cell contains a name count a range of cells >0

    Started by sharky1978‎, 02-15-2022 04:39 AM
    2 Attachment(s)
    • 3
    • 257
    AliGW
    02-15-2022, 05:00 AM Go to last post

  28. [SOLVED] Present values based on the header from large data base

    Started by Kobipp‎, 02-14-2022 12:20 PM
    3 Attachment(s)
    • 4
    • 186
    Kobipp
    02-15-2022, 02:49 AM Go to last post

  29. [SOLVED] Unique values formula returning zero

    Started by kollur‎, 02-15-2022 01:44 AM
    2 Attachment(s)
    • 4
    • 691
    wk9128
    02-15-2022, 02:14 AM Go to last post

  30. [SOLVED] Lookup values with multiple criteria

    Started by avinash21‎, 02-04-2022 05:31 AM
    2 Attachment(s)
    • 6
    • 279
    avinash21
    02-15-2022, 12:59 AM Go to last post

  31. Companies that use products we're familiar with

    Started by Zatara‎, 02-14-2022 09:11 PM
    1 Attachment(s)
    • 2
    • 169
    alansidman
    02-15-2022, 12:46 AM Go to last post

  32. Tables referencing main table cant use sort

    Started by akdm100‎, 02-14-2022 02:48 AM
    2 Attachment(s)
    • 1
    • 203
    JeteMc
    02-15-2022, 12:00 AM Go to last post

  33. Address multiple worksheets

    Started by egit123‎, 02-13-2022 01:40 PM
    1 Attachment(s)
    • 7
    • 309
    menem
    02-14-2022, 11:29 PM Go to last post

  34. [SOLVED] Simple formula IFS/ COUNTIF

    Started by wanmuhd‎, 02-14-2022 10:20 PM
    1 Attachment(s)
    • 4
    • 188
    Gregb11
    02-14-2022, 11:21 PM Go to last post

  35. [SOLVED] Copy nth Row Cell to Column

    Started by Ian McPherson‎, 02-14-2022 08:10 PM
    1 Attachment(s)
    • 4
    • 240
    wk9128
    02-14-2022, 10:21 PM Go to last post

  36. [SOLVED] COUNTING Text Cells with Duplicates Based on Multi-base criteria

    Started by TMains‎, 02-09-2022 06:37 PM
    2 Attachment(s)
    • 8
    • 359
    wk9128
    02-14-2022, 09:58 PM Go to last post

  37. [SOLVED] Lookup a value in a range based off another value

    Started by Nemo_Slumbers‎, 02-14-2022 08:41 PM
    index, lookup, match
    • 1
    • 276
    wk9128
    02-14-2022, 09:51 PM Go to last post

  38. Build a table of companies that match our profile

    Started by Zatara‎, 02-14-2022 08:43 PM
    1 Attachment(s)
    • 1
    • 138
    alansidman
    02-14-2022, 09:03 PM Go to last post

  39. [SOLVED] Having Trouble Coming up with Combination Lookup value based on Rank Result

    Started by tvieson‎, 02-12-2022 01:08 PM
    1 Attachment(s)
    • 11
    • 360
    JeteMc
    02-14-2022, 07:45 PM Go to last post

  40. summing across multiple worksheets based on category

    Started by Zenmusicman‎, 02-14-2022 05:53 PM
    1 Attachment(s)
    • 5
    • 208
    mphillips
    02-14-2022, 06:53 PM Go to last post

  41. Creating a Dynamic List that pulls from one tab to another based on a criteria

    Started by CMM1234‎, 02-14-2022 04:45 PM
    dynamic list, if formula 1 Attachment(s)
    • 5
    • 278
    Fluff13
    02-14-2022, 05:46 PM Go to last post

  42. Which LOOKUP function to use and Keeping Formula Column Constant when Inserting Columns

    Started by wendy823‎, 02-14-2022 12:31 PM
    1 Attachment(s)
    • 3
    • 246
    AliGW
    02-14-2022, 05:23 PM Go to last post

  43. Moved: Custom format date and time on import

    Started by bdouglas1011‎, 02-14-2022 04:57 PM
    •  
    •  

  44. Data Validation formula - choosing from a list of multiply cells and value's calculated

    Started by lord anubis‎, 02-14-2022 09:46 AM
    1 Attachment(s)
    • 1
    • 193
    FDibbins
    02-14-2022, 03:55 PM Go to last post

  45. countifs formula help

    Started by herbie.000‎, 02-14-2022 01:44 PM
    • 3
    • 205
    The_Snook
    02-14-2022, 03:17 PM Go to last post

  46. [SOLVED] Formula to pick up last 6 months data.

    Started by kris01‎, 02-14-2022 07:11 AM
    3 Attachment(s)
    • 13
    • 673
    TMS
    02-14-2022, 01:54 PM Go to last post

  47. [SOLVED] Checking to see if multiple values from one list exist in the other

    Started by makaveeti‎, 02-14-2022 08:36 AM
    6 Attachment(s)
    • 12
    • 355
    Glenn Kennedy
    02-14-2022, 12:44 PM Go to last post

  48. [SOLVED] Need help- Power Query Merge function return null value!

    Started by marvin-tech‎, 02-10-2022 01:10 PM
    • 4
    • 1,716
    AliGW
    02-14-2022, 12:23 PM Go to last post

  49. Populating a list

    Started by barbz11‎, 02-11-2022 12:47 PM
    5 Attachment(s)
    • 9
    • 323
    JohnTopley
    02-14-2022, 12:13 PM Go to last post

  50. [SOLVED] Circular references

    Started by Osprey2‎, 02-10-2022 11:58 AM
    • 3
    • 327
    AliGW
    02-14-2022, 09:49 AM Go to last post
+ Post New Thread
Page 351 of 5614 FirstFirst ... 351 ...

Forum Information and Options

Users Browsing this Forum

There are currently 42 users browsing this forum. (1 members & 41 guests)

  1. CARACALLA

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