+ Post New Thread
Page 2013 of 5628 FirstFirst ... 2013 ...
Threads 100601 to 100650 of 281372

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

  1. retrieve all unique values from two columns (i.e. get rid of duplicates and blank rows)

    Started by regresss‎, 05-29-2015 02:35 PM
    1 Attachment(s)
    • 3
    • 437
    AlKey
    05-29-2015, 04:20 PM Go to last post

  2. Find a value in a list of data

    Started by globesh‎, 05-29-2015 11:36 AM
    date, find
    • 2
    • 702
    nigelbloomy
    05-29-2015, 04:18 PM Go to last post

  3. use Formula to make Formula?

    Started by WanderingJack‎, 05-29-2015 03:07 PM
    excel, formula, match, reference, vlookup
    • 3
    • 622
    WanderingJack
    05-29-2015, 03:58 PM Go to last post

  4. Beauty of formulas and comparison with VBA solutions

    Started by regresss‎, 05-29-2015 03:13 PM
    • 1
    • 446
    Kyle123
    05-29-2015, 03:40 PM Go to last post

  5. [SOLVED] Hyperlink to a cell containing a reference

    Started by taxboy2010‎, 05-28-2015 10:17 AM
    formula, hyperlink, navigation, reference, tab 1 Attachment(s)
    • 5
    • 1,219
    taxboy2010
    05-29-2015, 03:23 PM Go to last post

  6. Using AND/OR functions together - help please

    Started by beerjjj‎, 05-29-2015 07:41 AM
    2 Attachment(s)
    • 8
    • 335
    beerjjj
    05-29-2015, 03:03 PM Go to last post

  7. How to count text entered with ALT+ENTER using a count function

    Started by bethy1234‎, 05-29-2015 11:12 AM
    • 2
    • 1,802
    bethy1234
    05-29-2015, 02:41 PM Go to last post

  8. Need help populating a formula that works under certain requirements

    Started by zbastien‎, 05-29-2015 01:30 PM
    1 Attachment(s)
    • 1
    • 370
    Kaper
    05-29-2015, 02:20 PM Go to last post

  9. Formula to Verify/Match Strings of text

    Started by jav171‎, 05-29-2015 10:14 AM
    1 Attachment(s)
    • 3
    • 435
    JeteMc
    05-29-2015, 01:56 PM Go to last post

  10. [SOLVED] Using OR Function/Formula (stuck on "* *" possibilites)

    Started by Alphabex‎, 05-29-2015 12:56 PM
    or formula
    • 13
    • 743
    daddylonglegs
    05-29-2015, 01:40 PM Go to last post

  11. Resloved, Thanks ..!! Please help, summery data from many sheet to one sheet

    Started by Addiaz‎, 05-26-2015 11:01 PM
    4 Attachment(s)
    • 10
    • 667
    JohnTopley
    05-29-2015, 01:18 PM Go to last post

  12. Finding speicifc values in a list and then using a vlookup

    Started by Moses76‎, 05-29-2015 11:29 AM
    3 Attachment(s)
    • 7
    • 336
    Moses76
    05-29-2015, 01:12 PM Go to last post

  13. [SOLVED] Date format in CSV file

    Started by rizmomin‎, 05-29-2015 12:57 AM
    2 Attachment(s)
    • 5
    • 335
    Moo the Dog
    05-29-2015, 01:07 PM Go to last post

  14. COUNTIF Problem

    Started by Laingy24‎, 05-28-2015 11:56 AM
    2 Attachment(s)
    • 8
    • 534
    Glenn Kennedy
    05-29-2015, 01:00 PM Go to last post

  15. [SOLVED] Dyanmic range sandwiched between blank rows

    Started by SinJinQLB‎, 05-29-2015 11:42 AM
    2 Attachment(s)
    • 1
    • 395
    nigelbloomy
    05-29-2015, 12:47 PM Go to last post

  16. If formula that includes or

    Started by ellie2014‎, 05-29-2015 12:03 PM
    • 4
    • 302
    etaf
    05-29-2015, 12:44 PM Go to last post

  17. Highlight cells based on number

    Started by cossie2k‎, 05-29-2015 10:56 AM
    4 Attachment(s)
    • 13
    • 673
    Glenn Kennedy
    05-29-2015, 12:24 PM Go to last post

  18. [SOLVED] Combine 2 functions

    Started by afterthoughts‎, 05-29-2015 11:37 AM
    • 3
    • 342
    Glenn Kennedy
    05-29-2015, 12:14 PM Go to last post

  19. Clear cell contents of drop down box based on condition

    Started by Pami‎, 05-27-2015 06:25 PM
    1 Attachment(s)
    • 3
    • 984
    Pami
    05-29-2015, 12:05 PM Go to last post

  20. [SOLVED] index match formula won't fill across columns or adjust if column is deleted

    Started by duvius‎, 05-29-2015 10:03 AM
    1 Attachment(s)
    • 1
    • 583
    CRIMEDOG
    05-29-2015, 11:57 AM Go to last post

  21. [SOLVED] Exclude Values From List That Contain Specific Text

    Started by strother1990‎, 05-29-2015 11:03 AM
    2 Attachment(s)
    • 6
    • 444
    strother1990
    05-29-2015, 11:50 AM Go to last post

  22. finding out how a total is made up

    Started by JDDR‎, 05-29-2015 08:30 AM
    1 Attachment(s)
    • 1
    • 347
    José Augusto
    05-29-2015, 11:47 AM Go to last post

  23. Re:counting text entries entered using alt+enter

    Started by bethy1234‎, 05-29-2015 11:10 AM
    1 Attachment(s)
    • 3
    • 367
    AlKey
    05-29-2015, 11:32 AM Go to last post

  24. Smile HELP! Search for String from Col A, Tab 2 in Col F, Tab 1 and Return Value in Col B, Tab 2

    Started by gmrush‎, 05-28-2015 01:00 PM
    9 Attachment(s)
    • 15
    • 717
    gmrush
    05-29-2015, 11:26 AM Go to last post

  25. If statement? Or Replace?

    Started by Jayfaas‎, 05-29-2015 09:40 AM
    1 Attachment(s)
    • 1
    • 331
    José Augusto
    05-29-2015, 10:25 AM Go to last post

  26. Retriving last N number of dates before first zeros

    Started by thilag‎, 05-29-2015 10:13 AM
    2 Attachment(s)
    • 2
    • 326
    Glenn Kennedy
    05-29-2015, 10:23 AM Go to last post

  27. Percentage based on multiple criteria

    Started by wburbage‎, 05-28-2015 08:41 PM
    1 Attachment(s)
    • 3
    • 645
    JeteMc
    05-29-2015, 10:16 AM Go to last post

  28. [SOLVED] Formula and Sorts by Ranks.

    Started by javijuan‎, 05-29-2015 07:47 AM
    formula, rank, site, sort 2 Attachment(s)
    • 5
    • 808
    javijuan
    05-29-2015, 10:01 AM Go to last post

  29. Post Help needed to fix INT MOD formula (sample attached)

    Started by hulot‎, 05-29-2015 05:49 AM
    3 Attachment(s)
    • 5
    • 495
    kvsrinivasamurthy
    05-29-2015, 09:56 AM Go to last post

  30. Question Cumulative Sum for last 7 days

    Started by Jumbo744‎, 05-28-2015 11:48 PM
    1 Attachment(s)
    • 2
    • 1,603
    Jumbo744
    05-29-2015, 09:53 AM Go to last post

  31. [SOLVED] How to add cells together using specific criteria

    Started by Builditbob‎, 05-27-2015 05:07 PM
    1 Attachment(s)
    • 4
    • 444
    samba_ravi
    05-29-2015, 09:10 AM Go to last post

  32. [SOLVED] Tell me about countifs & sumifs

    Started by keshavtale‎, 05-29-2015 08:21 AM
    1 Attachment(s)
    • 6
    • 639
    TMS
    05-29-2015, 09:01 AM Go to last post

  33. [SOLVED] SUMIF from TABLE

    Started by TZ Saic‎, 05-29-2015 02:49 AM
    3 Attachment(s)
    • 10
    • 419
    jayajaya_4
    05-29-2015, 08:51 AM Go to last post

  34. Need to find and replace with work sheet name part of a formula

    Started by aripori‎, 05-29-2015 07:24 AM
    1 Attachment(s)
    • 1
    • 403
    morevijay1982
    05-29-2015, 07:45 AM Go to last post

  35. Please help! Sumproduct formula with >0 returning zero values

    Started by LBundy‎, 05-26-2015 04:48 AM
    4 Attachment(s)
    • 13
    • 665
    kvsrinivasamurthy
    05-29-2015, 07:12 AM Go to last post

  36. Countif function when range isn't continous

    Started by hassjohn‎, 05-29-2015 05:32 AM
    countif, range 1 Attachment(s)
    • 2
    • 636
    Tony Valko
    05-29-2015, 06:39 AM Go to last post

  37. Summing up values when there is a gap

    Started by euklid123‎, 05-29-2015 05:13 AM
    chart, sum 2 Attachment(s)
    • 3
    • 427
    Sam Capricci
    05-29-2015, 05:29 AM Go to last post

  38. Is it possible to have Double Click and WS Change in the same one WS

    Started by tuongtu3‎, 05-28-2015 10:19 PM
    • 1
    • 251
    Fotis1991
    05-29-2015, 05:11 AM Go to last post

  39. Problem with anniuity payment plan with residual value

    Started by Bogi‎, 05-29-2015 03:09 AM
    1 Attachment(s)
    • 0
    • 399
    Bogi
    05-29-2015, 03:09 AM Go to last post

  40. [SOLVED] Vlookup and Hlookup?

    Started by MB1983DK‎, 05-28-2015 03:02 PM
    1 Attachment(s)
    • 2
    • 372
    MB1983DK
    05-29-2015, 02:20 AM Go to last post

  41. Multiple values, show second or third

    Started by Excelsior67‎, 05-20-2015 08:03 AM
    • 1
    • 421
    tuph
    05-29-2015, 02:14 AM Go to last post

  42. [SOLVED] ISBlank

    Started by afterthoughts‎, 05-29-2015 12:41 AM
    • 6
    • 355
    afterthoughts
    05-29-2015, 01:51 AM Go to last post

  43. [SOLVED] IF or Vlookup fuction

    Started by leakhna‎, 05-28-2015 10:42 PM
    2 Attachment(s)
    • 1
    • 305
    boopathiraja
    05-29-2015, 12:24 AM Go to last post

  44. [SOLVED] Date/Time Conversion- Yet again

    Started by hammer2‎, 05-28-2015 11:50 PM
    1 Attachment(s)
    • 2
    • 391
    hammer2
    05-29-2015, 12:12 AM Go to last post

  45. [SOLVED] Help require to get a paid/balance account

    Started by mso3‎, 05-28-2015 01:12 PM
    formula 1 Attachment(s)
    • 7
    • 593
    mso3
    05-28-2015, 10:44 PM Go to last post

  46. If a cell contains some thing add a random bit of information from another cell

    Started by zkgabriel‎, 05-28-2015 10:03 PM
    • 1
    • 243
    Crooza
    05-28-2015, 10:20 PM Go to last post

  47. [SOLVED] Week Numbering

    Started by amitananddey‎, 05-17-2015 03:34 AM
    3 Attachment(s)
    • 10
    • 726
    BlindAlley
    05-28-2015, 09:10 PM Go to last post

  48. [SOLVED] Create Attendance Report using Lists of Participants

    Started by CWatsonJr‎, 05-28-2015 04:33 PM
    2 Attachment(s)
    • 10
    • 742
    Tony Valko
    05-28-2015, 09:07 PM Go to last post

  49. Question Dynamic Concatenate based on varying cell address references

    Started by sambusby‎, 05-28-2015 08:12 PM
    concatenate, dynamic range, indirect address, start and end point 1 Attachment(s)
    • 1
    • 1,102
    Tony Valko
    05-28-2015, 08:55 PM Go to last post

  50. Question Dynamic Concatenate based on varying cell address references

    Started by sambusby‎, 05-28-2015 08:18 PM
    concatenate, dynamic range, indirect addressing, start and end point
    • 1
    • 803
    sambusby
    05-28-2015, 08:29 PM Go to last post
+ Post New Thread
Page 2013 of 5628 FirstFirst ... 2013 ...

Forum Information and Options

Users Browsing this Forum

There are currently 47 users browsing this forum. (7 members & 40 guests)

  1. Glenn Kennedy,
  2. kvsrinivasamurthy,
  3. major_johnson,
  4. Phuocam,
  5. RaulSerg,
  6. Sam Capricci

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