+ Post New Thread
Page 1451 of 5615 FirstFirst ... 1451 ...
Threads 72501 to 72550 of 280701

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

  1. [SOLVED] How to split the Total Outstanding of Loan Applicants in various Days Buckets

    Started by purav82‎, 04-06-2017 01:10 PM
    3 Attachment(s)
    • 9
    • 543
    JeteMc
    04-11-2017, 09:00 AM Go to last post

  2. Lightbulb identifying duplicate in a range of numbers

    Started by shuaibfarouk‎, 04-10-2017 04:12 PM
    duplicate, in range of numbers 2 Attachment(s)
    • 8
    • 555
    Phuocam
    04-11-2017, 08:52 AM Go to last post

  3. [SOLVED] Range of values greater than particular column's values

    Started by LesliePrabakar‎, 04-11-2017 06:30 AM
    4 Attachment(s)
    • 20
    • 589
    AliGW
    04-11-2017, 08:43 AM Go to last post

  4. [SOLVED] not sure what forumla i need! vlook up; index; match??

    Started by littlefoot‎, 02-28-2017 05:41 AM
    4 Attachment(s)
    • 11
    • 647
    Glenn Kennedy
    04-11-2017, 08:19 AM Go to last post

  5. Count IF Formula Assistance- Adding all values in a row for a specific region.

    Started by Marc.Cam‎, 04-07-2017 06:39 PM
    countif formula, pivot table count 2 Attachment(s)
    • 5
    • 402
    jeffreybrown
    04-11-2017, 08:00 AM Go to last post

  6. how do i add formulas together

    Started by jono121ukk‎, 04-10-2017 06:09 PM
    1 Attachment(s)
    • 4
    • 418
    sandy666
    04-11-2017, 07:52 AM Go to last post

  7. [SOLVED] Multiple criteria for If statement

    Started by emearley‎, 04-03-2017 02:52 PM
    3 Attachment(s)
    • 13
    • 719
    emearley
    04-11-2017, 07:28 AM Go to last post

  8. Copy names over to the next day when doing inventory

    Started by Shamz41‎, 04-11-2017 06:50 AM
    1 Attachment(s)
    • 1
    • 264
    AliGW
    04-11-2017, 07:25 AM Go to last post

  9. copy over names to next column on current date

    Started by Shamz41‎, 04-11-2017 12:40 AM
    1 Attachment(s)
    • 2
    • 288
    AliGW
    04-11-2017, 07:24 AM Go to last post

  10. Matching Date and year in one cell to date and year in another cell

    Started by Harshabn‎, 04-11-2017 05:50 AM
    1 Attachment(s)
    • 5
    • 354
    bebo021999
    04-11-2017, 06:57 AM Go to last post

  11. [SOLVED] How to get second FY that's April 2015 March 2016?

    Started by mso3‎, 04-11-2017 05:49 AM
    1 Attachment(s)
    • 2
    • 453
    mso3
    04-11-2017, 06:15 AM Go to last post

  12. [SOLVED] Countifs query

    Started by thega‎, 04-11-2017 05:09 AM
    1 Attachment(s)
    • 5
    • 305
    AliGW
    04-11-2017, 05:27 AM Go to last post

  13. [SOLVED] How to get month and year of previous and current financial year?

    Started by mso3‎, 04-09-2017 11:58 AM
    4 Attachment(s)
    • 19
    • 1,013
    AliGW
    04-11-2017, 05:19 AM Go to last post

  14. Finding a date when multiple criteria are met

    Started by alex_a‎, 04-11-2017 03:22 AM
    • 1
    • 251
    AliGW
    04-11-2017, 03:24 AM Go to last post

  15. Looks for 5 words similar like HALLOED HELLOED HILLOED HOLLOED HULLOED

    Started by makinmomb‎, 04-08-2017 08:46 AM
    1 Attachment(s)
    • 11
    • 631
    canapone
    04-11-2017, 02:37 AM Go to last post

  16. [SOLVED] Custom Number - Combine Attirbutes of Currency & Accounting

    Started by lipper79‎, 04-10-2017 01:59 PM
    • 4
    • 393
    kev_
    04-11-2017, 01:47 AM Go to last post

  17. [SOLVED] Percentage to display full marks

    Started by randallftan‎, 04-11-2017 12:01 AM
    • 4
    • 340
    randallftan
    04-11-2017, 01:17 AM Go to last post

  18. Talking Needing help with my personal finance spreadsheet

    Started by Charlotte2017‎, 04-10-2017 11:14 PM
    function help, please give a solution 1 Attachment(s)
    • 3
    • 486
    NickyC
    04-11-2017, 12:35 AM Go to last post

  19. formula or function to return a string of numbers based on a counter

    Started by llomax83‎, 04-09-2017 05:51 PM
    2 Attachment(s)
    • 3
    • 321
    JeteMc
    04-10-2017, 09:09 PM Go to last post

  20. [SOLVED] Simplify a complex formula with many logical functions

    Started by Trebor777‎, 04-09-2017 08:21 AM
    1 Attachment(s)
    • 7
    • 425
    FlameRetired
    04-10-2017, 09:02 PM Go to last post

  21. Talking Request for information on how to ignore leading Zeroes in Average Function

    Started by Joshi Ram‎, 04-10-2017 05:18 PM
    average first x non blank
    • 8
    • 991
    protonLeah
    04-10-2017, 07:38 PM Go to last post

  22. If formula with multiple validation criteria

    Started by Aussibuilder50000‎, 04-09-2017 06:00 PM
    2 Attachment(s)
    • 2
    • 269
    Aussibuilder50000
    04-10-2017, 06:35 PM Go to last post

  23. Formula? to find existing use of a reference number across 12 tabs then find next avail #

    Started by Miskondukt‎, 04-05-2017 02:27 PM
    1 Attachment(s)
    • 1
    • 439
    dflak
    04-10-2017, 03:33 PM Go to last post

  24. [SOLVED] Offset from hlookup...

    Started by Ourkid123uk‎, 04-10-2017 02:21 PM
    1 Attachment(s)
    • 2
    • 416
    Ourkid123uk
    04-10-2017, 03:30 PM Go to last post

  25. [SOLVED] Help with identifying duplicate cells across multiple sheets in a workbook

    Started by CraigYH‎, 04-10-2017 11:32 AM
    2 Attachment(s)
    • 7
    • 418
    PeteABC123
    04-10-2017, 02:38 PM Go to last post

  26. Smile [SOLVED] Formula help! Lookup function needing to be used to return largest value

    Started by jkhoury1‎, 04-10-2017 12:46 PM
    2 Attachment(s)
    • 8
    • 443
    Glenn Kennedy
    04-10-2017, 02:12 PM Go to last post

  27. [SOLVED] VLookup / sumproduct / sumif ??? help....

    Started by TomP1988‎, 04-10-2017 10:26 AM
    2 Attachment(s)
    • 5
    • 588
    Glenn Kennedy
    04-10-2017, 11:30 AM Go to last post

  28. How do I create and extract data from a rolling / continuous work roster using excel?

    Started by Brendan1908‎, 04-10-2017 07:53 AM
    1 Attachment(s)
    • 3
    • 761
    davsth
    04-10-2017, 10:54 AM Go to last post

  29. [SOLVED] Sort/count marks according to mark ranges? (Help me with a formula)

    Started by grcd‎, 04-10-2017 05:58 AM
    4 Attachment(s)
    • 12
    • 587
    grcd
    04-10-2017, 10:42 AM Go to last post

  30. Hlookup TYPE lookup

    Started by sungen99‎, 04-10-2017 10:09 AM
    • 3
    • 293
    AliGW
    04-10-2017, 10:35 AM Go to last post

  31. [SOLVED] Counting totals between dates and product

    Started by erik_t_viking‎, 04-10-2017 06:47 AM
    2 Attachment(s)
    • 10
    • 419
    JohnTopley
    04-10-2017, 09:03 AM Go to last post

  32. [SOLVED] Assistance with IF directing to multiple cells

    Started by tomdss‎, 04-10-2017 06:35 AM
    2 Attachment(s)
    • 4
    • 320
    tomdss
    04-10-2017, 08:52 AM Go to last post

  33. Spreadsheets

    Started by Brendan1908‎, 04-10-2017 06:45 AM
    • 2
    • 242
    AliGW
    04-10-2017, 07:58 AM Go to last post

  34. [SOLVED] SUM IF with two ranges of non contiguous cells

    Started by kkkingsley‎, 04-07-2017 06:27 AM
    1 Attachment(s)
    • 4
    • 2,710
    Glenn Kennedy
    04-10-2017, 07:10 AM Go to last post

  35. [SOLVED] Index and SumProduct

    Started by josvill‎, 04-10-2017 06:38 AM
    1 Attachment(s)
    • 1
    • 262
    josvill
    04-10-2017, 06:41 AM Go to last post

  36. [SOLVED] how to countifs to count till the colored row

    Started by narsing18‎, 04-06-2017 07:37 AM
    excel formula 2 Attachment(s)
    • 20
    • 816
    narsing18
    04-10-2017, 06:30 AM Go to last post

  37. Moved: CountIF Help?

    Started by Mrmarc‎, 04-09-2017 06:07 AM
    •  
    •  

  38. Create data validation list

    Started by KriZo‎, 04-06-2017 10:41 AM
    2 Attachment(s)
    • 4
    • 283
    AliGW
    04-10-2017, 04:11 AM Go to last post

  39. How to find the next higher value??

    Started by JonasP‎, 04-10-2017 04:03 AM
    1 Attachment(s)
    • 1
    • 363
    AliGW
    04-10-2017, 04:04 AM Go to last post

  40. [SOLVED] Formula to unpivot data

    Started by chullan88‎, 04-10-2017 02:16 AM
    2 Attachment(s)
    • 3
    • 3,255
    Glenn Kennedy
    04-10-2017, 03:55 AM Go to last post

  41. Vlookup only returning the first line of data requested

    Started by prowsie‎, 04-10-2017 02:17 AM
    1 Attachment(s)
    • 5
    • 599
    AliGW
    04-10-2017, 02:42 AM Go to last post

  42. [SOLVED] A complex SUMIFS operation

    Started by canusesomeexcelhelp‎, 04-09-2017 11:50 PM
    4 Attachment(s)
    • 11
    • 946
    canapone
    04-10-2017, 01:35 AM Go to last post

  43. [SOLVED] Formula to show unique values and display horizontally based on condition

    Started by Rygor‎, 04-10-2017 01:24 AM
    1 Attachment(s)
    • 1
    • 1,396
    shukla.ankur281190
    04-10-2017, 01:34 AM Go to last post

  44. Post [SOLVED] Searching for multiples and returning a name

    Started by vbcoachwasi‎, 04-08-2017 10:01 PM
    countifs, or function
    • 6
    • 485
    FDibbins
    04-10-2017, 12:38 AM Go to last post

  45. Use IF Function to decide 1 of 3 outcomes from 2 columns of numbers

    Started by dougkpga‎, 04-07-2017 02:02 PM
    • 7
    • 295
    FDibbins
    04-10-2017, 12:36 AM Go to last post

  46. [SOLVED] Calculating unique values from an array

    Started by canusesomeexcelhelp‎, 04-09-2017 06:34 PM
    1 Attachment(s)
    • 2
    • 293
    canusesomeexcelhelp
    04-09-2017, 08:43 PM Go to last post

  47. [SOLVED] How do I conditional format freeforms?

    Started by kevinu‎, 04-07-2017 09:00 PM
    1 Attachment(s)
    • 3
    • 358
    kevinu
    04-09-2017, 07:09 PM Go to last post

  48. [SOLVED] [Solved] Making Dependent List from Cell Values

    Started by jbagnall2004‎, 04-09-2017 02:38 PM
    1 Attachment(s)
    • 19
    • 703
    TMS
    04-09-2017, 06:36 PM Go to last post

  49. [SOLVED] VLOOKUP or INDEX MATCH FORMULA

    Started by MYEM1983‎, 04-09-2017 02:02 PM
    index and match, vlookup 2 Attachment(s)
    • 4
    • 473
    MYEM1983
    04-09-2017, 05:04 PM Go to last post

  50. [SOLVED] summary table

    Started by samot79‎, 04-09-2017 02:49 PM
    1 Attachment(s)
    • 2
    • 254
    samot79
    04-09-2017, 04:45 PM Go to last post
+ Post New Thread
Page 1451 of 5615 FirstFirst ... 1451 ...

Forum Information and Options

Users Browsing this Forum

There are currently 65 users browsing this forum. (5 members & 60 guests)

  1. a15995,
  2. cat_oulala,
  3. ohitsadonkey,
  4. RaulSerg

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