+ Post New Thread
Page 601 of 5611 FirstFirst ... 601 ...
Threads 30001 to 30050 of 280528

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

  1. [SOLVED] How to Show the Number of Days an Action is Overdue

    Started by AliMcG‎, 11-11-2020 10:52 AM
    1 Attachment(s)
    • 3
    • 364
    AliGW
    11-11-2020, 04:23 PM Go to last post

  2. [SOLVED] analyzing existing combinations

    Started by Essen‎, 11-02-2020 07:44 AM
    3 Attachment(s)
    • 7
    • 479
    JeteMc
    11-11-2020, 03:59 PM Go to last post

  3. How to color cells based on if that number is greater or less than another number years?

    Started by anoble1‎, 11-11-2020 03:26 PM
    • 1
    • 228
    Richard Buttrey
    11-11-2020, 03:44 PM Go to last post

  4. [SOLVED] sum combining data from more than one tables?

    Started by S@S‎, 11-11-2020 11:49 AM
    4 Attachment(s)
    • 6
    • 308
    S@S
    11-11-2020, 03:20 PM Go to last post

  5. [SOLVED] Help with Formula to remove decimals

    Started by kgtrader‎, 11-11-2020 02:01 PM
    3 Attachment(s)
    • 6
    • 293
    kgtrader
    11-11-2020, 02:52 PM Go to last post

  6. Excel formula

    Started by Alexgg‎, 11-11-2020 11:58 AM
    1 Attachment(s)
    • 7
    • 246
    alansidman
    11-11-2020, 02:28 PM Go to last post

  7. IF Statement & lookup to other columns - Job Application Spreadsheet

    Started by lexa-midnight‎, 11-03-2020 08:39 AM
    and_or, formula 3 Attachment(s)
    • 6
    • 340
    lexa-midnight
    11-11-2020, 01:49 PM Go to last post

  8. Question [SOLVED] Convert or split text to columns

    Started by costi_linho12‎, 11-11-2020 09:16 AM
    3 Attachment(s)
    • 5
    • 236
    costi_linho12
    11-11-2020, 01:46 PM Go to last post

  9. [SOLVED] Help Required for IF Formula (Current Points)

    Started by kgtrader‎, 11-10-2020 10:41 PM
    1 Attachment(s)
    • 2
    • 215
    kgtrader
    11-11-2020, 01:42 PM Go to last post

  10. [SOLVED] VLOOKUP with two conditions

    Started by Markulane‎, 11-11-2020 12:10 PM
    1 Attachment(s)
    • 3
    • 190
    Markulane
    11-11-2020, 12:49 PM Go to last post

  11. Post Want to Learn: Learning which employee takes photos for a specific task in a location

    Started by ImpressiveAce‎, 11-11-2020 11:40 AM
    1 Attachment(s)
    • 2
    • 168
    alansidman
    11-11-2020, 12:48 PM Go to last post

  12. [SOLVED] Stable Formula for Age from Id

    Started by sintek‎, 11-11-2020 11:56 AM
    • 6
    • 195
    sintek
    11-11-2020, 12:29 PM Go to last post

  13. IF() combined with MONTH() and YEAR() inside another IF() function

    Started by vba_php‎, 11-11-2020 03:54 AM
    5 Attachment(s)
    • 21
    • 335
    vba_php
    11-11-2020, 11:54 AM Go to last post

  14. = if > or 0 formula

    Started by jtglanton‎, 11-10-2020 06:12 PM
    • 3
    • 783
    Fluff13
    11-11-2020, 11:14 AM Go to last post

  15. [SOLVED] Formula to Remove Duplicates and Pull Unique Values into Desired Column

    Started by bjnockle‎, 11-10-2020 01:21 PM
    1 Attachment(s)
    • 7
    • 304
    Glenn Kennedy
    11-11-2020, 10:33 AM Go to last post

  16. [SOLVED] Aboslute reference Dragging formula help

    Started by Alexce101‎, 11-11-2020 09:56 AM
    1 Attachment(s)
    • 8
    • 335
    Fluff13
    11-11-2020, 10:28 AM Go to last post

  17. Red face [SOLVED] Comparing JSON data in two rows for every set of ID

    Started by chandramouliarun‎, 11-10-2020 07:23 AM
    comparison, json 2 Attachment(s)
    • 8
    • 824
    chandramouliarun
    11-11-2020, 10:08 AM Go to last post

  18. =IF Excel Formula that can use ranges

    Started by Overdahill‎, 11-11-2020 09:47 AM
    1 Attachment(s)
    • 3
    • 185
    AliGW
    11-11-2020, 10:00 AM Go to last post

  19. [SOLVED] Researching Formula

    Started by Naf_Fr‎, 10-22-2020 02:48 PM
    2 Attachment(s)
    • 5
    • 258
    Naf_Fr
    11-11-2020, 09:46 AM Go to last post

  20. [SOLVED] Lost in VLOOKUP, OFFSET, INDEX, etc...

    Started by JefferyK‎, 11-11-2020 07:17 AM
    index, offset, vlookup 3 Attachment(s)
    • 6
    • 389
    JefferyK
    11-11-2020, 09:36 AM Go to last post

  21. [SOLVED] Exclude range from randbetween

    Started by adamnc‎, 11-10-2020 03:41 PM
    4 Attachment(s)
    • 9
    • 2,612
    6StringJazzer
    11-11-2020, 08:56 AM Go to last post

  22. Extract Data Between "-"

    Started by Doug24‎, 11-11-2020 08:18 AM
    • 4
    • 203
    Glenn Kennedy
    11-11-2020, 08:44 AM Go to last post

  23. Search box for named ranges?

    Started by Nicolantonio‎, 11-11-2020 06:26 AM
    3 Attachment(s)
    • 4
    • 259
    torachan
    11-11-2020, 08:34 AM Go to last post

  24. Calculate Headcount by department, based on Hire date and Termination date

    Started by Cornelia‎, 11-22-2013 11:25 AM
    2 Attachment(s)
    • 10
    • 11,377
    cmetzker
    11-11-2020, 07:42 AM Go to last post

  25. [SOLVED] Create summary sheet

    Started by bkpraveen078‎, 11-11-2020 06:18 AM
    2 Attachment(s)
    • 3
    • 176
    bkpraveen078
    11-11-2020, 07:17 AM Go to last post

  26. Wink Subtraction Calculation w/requirement data is present

    Started by bdav1216‎, 11-07-2020 08:21 PM
    5 Attachment(s)
    • 13
    • 503
    Bo_Ry
    11-11-2020, 07:09 AM Go to last post

  27. [SOLVED] Match name to emails and move to sheet

    Started by leakingfuel‎, 11-11-2020 03:43 AM
    3 Attachment(s)
    • 7
    • 274
    AliGW
    11-11-2020, 06:33 AM Go to last post

  28. [SOLVED] vlookup from dropdown tab references

    Started by beternal‎, 11-11-2020 05:50 AM
    2 Attachment(s)
    • 5
    • 221
    Glenn Kennedy
    11-11-2020, 06:12 AM Go to last post

  29. [SOLVED] Excel Error - Double clicking turns calculated cells to #N/A

    Started by Barking_Mad‎, 11-10-2020 12:37 PM
    2 Attachment(s)
    • 10
    • 1,918
    AliGW
    11-11-2020, 05:58 AM Go to last post

  30. SUMPRODUCT and SUMIF that needs to be case sensitive

    Started by cr4p‎, 11-11-2020 05:28 AM
    1 Attachment(s)
    • 2
    • 351
    AliGW
    11-11-2020, 05:56 AM Go to last post

  31. Question Need some help with formulas to calculate drywall, metal studs and track.

    Started by Shopcat‎, 11-09-2020 03:22 PM
    1 Attachment(s)
    • 2
    • 608
    Jacc
    11-11-2020, 05:50 AM Go to last post

  32. Count values in a column based on data (with blanks) in another column

    Started by kehong216‎, 11-11-2020 03:56 AM
    2 Attachment(s)
    • 4
    • 216
    Glenn Kennedy
    11-11-2020, 05:45 AM Go to last post

  33. Copy different (and changing) length lists from multiple sheets

    Started by mccannmj4130‎, 11-04-2020 01:22 PM
    3 Attachment(s)
    • 6
    • 409
    kvsrinivasamurthy
    11-11-2020, 05:33 AM Go to last post

  34. I need help on an IF THEN table!

    Started by treybell3‎, 11-10-2020 01:30 PM
    3 Attachment(s)
    • 8
    • 309
    Glenn Kennedy
    11-11-2020, 03:39 AM Go to last post

  35. Unhappy [SOLVED] Get values from different sheets where different bits of data values match

    Started by neilosj‎, 11-10-2020 11:49 AM
    index, values, vlookup 1 Attachment(s)
    • 2
    • 332
    neilosj
    11-11-2020, 03:36 AM Go to last post

  36. Test date formated cell ON RANGE

    Started by bluntroller‎, 11-08-2020 02:12 AM
    • 12
    • 389
    Glenn Kennedy
    11-11-2020, 03:12 AM Go to last post

  37. Some help needed for an IF formula

    Started by kgtrader‎, 11-10-2020 10:32 PM
    1 Attachment(s)
    • 3
    • 180
    AliGW
    11-11-2020, 02:09 AM Go to last post

  38. Function help - If statement for forecasting

    Started by eshapiro‎, 11-09-2020 04:22 PM
    3 Attachment(s)
    • 8
    • 291
    alansidman
    11-11-2020, 01:04 AM Go to last post

  39. Need Help to do Multiple matching from 2 tabs in Excel Worksheet and list all combinations

    Started by BarathM‎, 11-10-2020 12:50 AM
    multiple matches 1 Attachment(s)
    • 5
    • 323
    Shareez Saleem
    11-11-2020, 12:57 AM Go to last post

  40. Help with formulas to determine percentage difference

    Started by Wet-Skunk‎, 11-10-2020 04:31 PM
    1 Attachment(s)
    • 2
    • 240
    bebo021999
    11-11-2020, 12:00 AM Go to last post

  41. [SOLVED] INDEX & MATCH from dropdown only returns 1st value

    Started by chaiyya345‎, 11-10-2020 09:31 PM
    1 Attachment(s)
    • 4
    • 244
    chaiyya345
    11-10-2020, 11:32 PM Go to last post

  42. Vlookup using one set of data with multiple results

    Started by Mark_3807054‎, 11-10-2020 11:06 AM
    2 Attachment(s)
    • 4
    • 319
    Mark_3807054
    11-10-2020, 07:15 PM Go to last post

  43. [SOLVED] Extract rows from table that match criteria in one column

    Started by Tonydonuts‎, 11-10-2020 03:04 PM
    4 Attachment(s)
    • 4
    • 432
    Tonydonuts
    11-10-2020, 05:10 PM Go to last post

  44. [SOLVED] Standard Deviation with one criteria

    Started by phbryan‎, 11-10-2020 02:55 PM
    stdevifs 1 Attachment(s)
    • 5
    • 305
    Kaper
    11-10-2020, 04:26 PM Go to last post

  45. Change the contents of the cell if a particular item from the drop down list is selected.

    Started by ramraodesai1991‎, 11-10-2020 08:36 AM
    • 4
    • 184
    TMS
    11-10-2020, 03:48 PM Go to last post

  46. [SOLVED] countif range of cells contains text from Column A

    Started by dlemoel‎, 11-10-2020 06:24 AM
    5 Attachment(s)
    • 11
    • 278
    Glenn Kennedy
    11-10-2020, 02:21 PM Go to last post

  47. Aggregating Values for ID with conditions

    Started by bdav1216‎, 11-10-2020 01:12 PM
    2 Attachment(s)
    • 5
    • 192
    Glenn Kennedy
    11-10-2020, 02:20 PM Go to last post

  48. [SOLVED] vlookup with count?

    Started by jeptik‎, 11-10-2020 01:55 PM
    2 Attachment(s)
    • 3
    • 220
    Glenn Kennedy
    11-10-2020, 02:18 PM Go to last post

  49. [SOLVED] Extract Values in a Column Excluding Blanks

    Started by bjnockle‎, 11-09-2020 10:44 AM
    2 Attachment(s)
    • 4
    • 381
    bjnockle
    11-10-2020, 01:32 PM Go to last post

  50. Angry Finding an average across multiple sheets but excluding 0

    Started by alexonfire‎, 11-10-2020 11:24 AM
    average, average formula
    • 9
    • 467
    alexonfire
    11-10-2020, 12:34 PM Go to last post
+ Post New Thread
Page 601 of 5611 FirstFirst ... 601 ...

Forum Information and Options

Users Browsing this Forum

There are currently 83 users browsing this forum. (2 members & 81 guests)

  1. alo2279,
  2. HansDouwe

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