+ Post New Thread
Page 1021 of 5614 FirstFirst ... 1021 ...
Threads 51001 to 51050 of 280698

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. Arrow OFFSET function from other .xls file

    Started by Oxcel‎, 01-22-2019 11:12 AM
    #value error, cross file, function, offset
    • 6
    • 965
    Oxcel
    01-25-2019, 04:18 AM Go to last post

  2. Does IF THEN apply to these calculations?

    Started by mmotorsport‎, 01-24-2019 05:19 PM
    • 9
    • 320
    AliGW
    01-25-2019, 02:02 AM Go to last post

  3. [SOLVED] Add multiple amount depending on same value

    Started by didierkassas‎, 01-24-2019 04:19 AM
    3 Attachment(s)
    • 8
    • 371
    didierkassas
    01-25-2019, 01:28 AM Go to last post

  4. Calc. combined mass of 6 masses & 900+ comb's of 6 to see if any comb. is out of range

    Started by dpk1nba‎, 01-23-2019 05:08 PM
    • 2
    • 214
    FlameRetired
    01-25-2019, 01:17 AM Go to last post

  5. Summing a column......sort of and oddly.

    Started by W7EKB‎, 01-25-2019 12:31 AM
    • 1
    • 248
    kersplash
    01-25-2019, 12:53 AM Go to last post

  6. IF AND Formula HELP

    Started by kevjkeenan‎, 01-14-2019 10:53 AM
    if and formula, if and formulas 4 Attachment(s)
    • 7
    • 420
    JeteMc
    01-24-2019, 11:09 PM Go to last post

  7. HIGHLIGHT DUPLICATES in COLUMN C across 14 worksheets

    Started by Triscia‎, 01-24-2019 01:42 PM
    • 2
    • 1,258
    David A Coop
    01-24-2019, 10:59 PM Go to last post

  8. Average if two conditions are met.

    Started by levpn‎, 12-26-2018 11:17 AM
    averageif, conditions
    • 5
    • 2,058
    Bo_Ry
    01-24-2019, 10:20 PM Go to last post

  9. Finding partial match in a range

    Started by miucus‎, 01-24-2019 09:45 PM
    1 Attachment(s)
    • 1
    • 277
    Bo_Ry
    01-24-2019, 10:14 PM Go to last post

  10. How to selectively filter the searches based on a criteria (Index function)

    Started by mutzie‎, 01-24-2019 08:46 PM
    2 Attachment(s)
    • 3
    • 265
    Glenn Kennedy
    01-24-2019, 09:39 PM Go to last post

  11. INDEX MATCH with multiple AND and OR criteria

    Started by marc01‎, 01-13-2019 12:42 PM
    2 Attachment(s)
    • 12
    • 487
    JeteMc
    01-24-2019, 09:08 PM Go to last post

  12. Copy Entire Row from One Spreadsheet to Another with Formula Only - in Mac

    Started by ManishaFin‎, 01-24-2019 05:34 PM
    1 Attachment(s)
    • 1
    • 232
    Pete_UK
    01-24-2019, 09:06 PM Go to last post

  13. [SOLVED] SUMIF Formula where the range is a column from an array

    Started by justinmt7‎, 01-23-2019 03:26 PM
    3 Attachment(s)
    • 8
    • 358
    justinmt7
    01-24-2019, 07:14 PM Go to last post

  14. Connect EXCEL to Web Page (Interactive)

    Started by marcomining‎, 01-24-2019 06:24 PM
    data connection, existing connection, web, web base excel, work folder
    • 0
    • 451
    marcomining
    01-24-2019, 06:24 PM Go to last post

  15. [SOLVED] Return Info from different tab, from second set of matched data

    Started by SSwwet2018‎, 01-18-2019 09:58 AM
    formulas 1 Attachment(s)
    • 9
    • 522
    AliGW
    01-24-2019, 06:12 PM Go to last post

  16. MAXIFS Problem - Non-Adjacent Range Name

    Started by willyt19712‎, 01-24-2019 05:37 PM
    maxifs, non-adjacent columns
    • 1
    • 1,056
    XOR LX
    01-24-2019, 06:02 PM Go to last post

  17. Total Changes by Month

    Started by BHartman‎, 01-21-2019 11:03 AM
    3 Attachment(s)
    • 15
    • 548
    FlameRetired
    01-24-2019, 04:44 PM Go to last post

  18. [SOLVED] match list with another column if within min/max range, assign categories

    Started by sparklerock23‎, 01-23-2019 10:13 PM
    2 Attachment(s)
    • 6
    • 511
    FlameRetired
    01-24-2019, 04:41 PM Go to last post

  19. [SOLVED] Conditional Formatting - Fill cells if field A & B match AND date is <=Today()

    Started by IT_Padawan‎, 01-22-2019 03:28 PM
    1 Attachment(s)
    • 4
    • 376
    Aardigspook
    01-24-2019, 04:33 PM Go to last post

  20. Change reading source for multiple cells

    Started by salminenaa‎, 01-24-2019 03:38 PM
    • 3
    • 322
    Sam Capricci
    01-24-2019, 04:17 PM Go to last post

  21. Question Countif Function to work similarly to Sumif Function

    Started by JMC1927‎, 01-24-2019 02:11 PM
    countif, functions and formula, sumif 3 Attachment(s)
    • 3
    • 969
    63falcondude
    01-24-2019, 04:10 PM Go to last post

  22. [SOLVED] Conditional format the cell that's different

    Started by jomili‎, 01-24-2019 12:22 PM
    1 Attachment(s)
    • 3
    • 327
    AliGW
    01-24-2019, 03:12 PM Go to last post

  23. [SOLVED] Index and Match returning #NA - Help please!

    Started by mpost54‎, 01-24-2019 01:43 PM
    1 Attachment(s)
    • 7
    • 1,595
    63falcondude
    01-24-2019, 03:03 PM Go to last post

  24. Trouble getting a conditional Sumproduct formula to work

    Started by mdp22‎, 01-24-2019 02:06 PM
    1 Attachment(s)
    • 3
    • 323
    Pete_UK
    01-24-2019, 02:55 PM Go to last post

  25. [SOLVED] I am trying to summarise worksheets in a workbook

    Started by Pickygame‎, 01-24-2019 02:29 PM
    1 Attachment(s)
    • 6
    • 266
    Pete_UK
    01-24-2019, 02:50 PM Go to last post

  26. IMPERIAL (i.e 13'-9 1/2" how to add or convert to a cell that will allow me to add

    Started by chacamasur‎, 01-24-2019 12:34 PM
    1 Attachment(s)
    • 4
    • 434
    chacamasur
    01-24-2019, 02:46 PM Go to last post

  27. Need help making multiple lists that are dependent on the first list.

    Started by bender1227‎, 01-23-2019 02:54 PM
    3 Attachment(s)
    • 5
    • 393
    Bo_Ry
    01-24-2019, 02:36 PM Go to last post

  28. [SOLVED] nested sumif statement help (is that the correct term?)

    Started by j449449‎, 01-17-2019 06:42 PM
    1 Attachment(s)
    • 6
    • 424
    TMS
    01-24-2019, 01:26 PM Go to last post

  29. Need help matching from array of 2 separate columns and returning adjacent cell

    Started by rebduv1‎, 01-24-2019 12:22 PM
    3 Attachment(s)
    • 2
    • 305
    Pete_UK
    01-24-2019, 01:05 PM Go to last post

  30. [SOLVED] Replace data in a table with same data from another table, bringing formatting with it.

    Started by Strykewulf‎, 11-17-2014 11:28 AM
    data automation, data formatting, replace a list of data, replace existing data
    • 2
    • 587
    Strykewulf
    01-24-2019, 12:55 PM Go to last post

  31. Assort person by lap time

    Started by brian461‎, 01-23-2019 02:36 PM
    • 1
    • 258
    dflak
    01-24-2019, 12:54 PM Go to last post

  32. [SOLVED] locking cells based on other cell drop-down selection

    Started by Strykewulf‎, 01-24-2019 12:50 PM
    lock cells, unlock cells, vba & excel
    • 0
    • 442
    Strykewulf
    01-24-2019, 12:50 PM Go to last post

  33. Sum of a set of values

    Started by akki2907‎, 01-23-2019 07:54 PM
    2 Attachment(s)
    • 3
    • 299
    Bo_Ry
    01-24-2019, 12:48 PM Go to last post

  34. Moving rows to another worksheet once cell value entered

    Started by DaveWoollven‎, 01-23-2019 12:23 PM
    • 1
    • 546
    dflak
    01-24-2019, 12:44 PM Go to last post

  35. sumif with truly approximate text match

    Started by nrff‎, 01-24-2019 10:19 AM
    1 Attachment(s)
    • 6
    • 670
    nrff
    01-24-2019, 11:57 AM Go to last post

  36. [SOLVED] Combining two find functions

    Started by dsteele111‎, 01-24-2019 10:53 AM
    2 Attachment(s)
    • 2
    • 283
    dsteele111
    01-24-2019, 11:50 AM Go to last post

  37. Moved: Using CELL function...

    Started by bvwalker1‎, 01-24-2019 11:31 AM
    •  
    •  

  38. Data Arrangement

    Started by Imran368‎, 01-24-2019 11:23 AM
    1 Attachment(s)
    • 1
    • 236
    AliGW
    01-24-2019, 11:27 AM Go to last post

  39. [SOLVED] Partial matching to multiple cells

    Started by dsteele111‎, 01-19-2019 06:07 PM
    function, joining text strings, match, matching, partial match 1 Attachment(s)
    • 4
    • 2,164
    dsteele111
    01-24-2019, 11:00 AM Go to last post

  40. Question [SOLVED] Help need for COUNTBLANK in one column based on another column

    Started by leautos13‎, 01-24-2019 08:47 AM
    countblank, countif and compare, countif based on criteria 2 Attachment(s)
    • 7
    • 391
    AliGW
    01-24-2019, 10:05 AM Go to last post

  41. help identifying areas of numeric congestion

    Started by Netzel‎, 01-23-2019 11:29 AM
    • 6
    • 391
    Netzel
    01-24-2019, 09:41 AM Go to last post

  42. Cool [SOLVED] Formula for Join Two Sheet into One.

    Started by Blek‎, 01-24-2019 12:18 AM
    join merge copy sheets, sheet copy 10 Attachment(s)
    • 8
    • 404
    Blek
    01-24-2019, 08:58 AM Go to last post

  43. Get multiple matches for the same lookup value

    Started by Frog213‎, 01-23-2019 03:55 PM
    2 Attachment(s)
    • 8
    • 360
    AliGW
    01-24-2019, 08:48 AM Go to last post

  44. [SOLVED] Name and Birth Date entered in multiple Sheet to be displayed in one main sheet

    Started by luckyros‎, 01-24-2019 05:15 AM
    4 Attachment(s)
    • 10
    • 504
    Pete_UK
    01-24-2019, 08:38 AM Go to last post

  45. Help needed with VLOOKUP OR INDEX

    Started by sam_1‎, 01-23-2019 05:04 PM
    2 Attachment(s)
    • 6
    • 332
    Glenn Kennedy
    01-24-2019, 08:35 AM Go to last post

  46. [SOLVED] MAX value of cell range if value of a different cell range is greater than X

    Started by Sambami‎, 01-24-2019 07:02 AM
    conditional max, max 1 Attachment(s)
    • 4
    • 366
    Glenn Kennedy
    01-24-2019, 08:35 AM Go to last post

  47. Conditional Formula = Cells copy the color of main cell if same answers

    Started by mutzie‎, 01-23-2019 08:39 PM
    2 Attachment(s)
    • 3
    • 304
    6StringJazzer
    01-24-2019, 08:26 AM Go to last post

  48. [SOLVED] enter country by company name and company cost

    Started by raysrains‎, 01-23-2019 01:40 PM
    1 Attachment(s)
    • 1
    • 384
    KOKOSEK
    01-24-2019, 08:25 AM Go to last post

  49. Automaticly change number

    Started by relinqu‎, 01-24-2019 07:18 AM
    • 3
    • 243
    Glenn Kennedy
    01-24-2019, 07:41 AM Go to last post

  50. [SOLVED] How to count the Data shifts from value to blank in a row

    Started by invendis‎, 01-24-2019 04:41 AM
    count, excel function 2 Attachment(s)
    • 6
    • 450
    AliGW
    01-24-2019, 07:39 AM Go to last post
+ Post New Thread
Page 1021 of 5614 FirstFirst ... 1021 ...

Forum Information and Options

Users Browsing this Forum

There are currently 75 users browsing this forum. (2 members & 73 guests)

  1. angelosison00,
  2. mamunparvezz

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