+ Post New Thread
Page 949 of 5615 FirstFirst ... 949 ...
Threads 47401 to 47450 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] Lookup based on data validation list

    Started by sjgidman82‎, 05-06-2019 09:56 AM
    2 Attachment(s)
    • 6
    • 442
    Fluff13
    05-10-2019, 01:05 PM Go to last post

  2. Question Can we use VLookup to fill in fields from Scattered Data ?

    Started by siddharthbeam‎, 05-10-2019 07:09 AM
    hlookup, microsoft excel, table array, vlookup, vlookup #value 1 Attachment(s)
    • 3
    • 540
    Melvosh
    05-10-2019, 12:42 PM Go to last post

  3. Looking to colour cell green if meets budget, red if exceeds.

    Started by Alex.Ch‎, 05-10-2019 11:35 AM
    1 Attachment(s)
    • 1
    • 225
    Pepe Le Mokko
    05-10-2019, 11:49 AM Go to last post

  4. formula: If cell is divisible by 10, then TRUE.. how to set it up?

    Started by cat3appr‎, 05-10-2019 10:57 AM
    4 Attachment(s)
    • 8
    • 1,220
    KOKOSEK
    05-10-2019, 11:37 AM Go to last post

  5. [SOLVED] Overtime Calculation by Day and Week Total Rules

    Started by meseleto‎, 05-09-2019 09:03 AM
    1 Attachment(s)
    • 4
    • 401
    jeffreybrown
    05-10-2019, 11:24 AM Go to last post

  6. Calculate Compass Heading between Points

    Started by StrigoNokto‎, 05-10-2019 07:07 AM
    4 Attachment(s)
    • 3
    • 1,495
    StrigoNokto
    05-10-2019, 10:59 AM Go to last post

  7. [SOLVED] IF and FIND formula

    Started by Ducky405‎, 05-09-2019 10:07 PM
    2 Attachment(s)
    • 4
    • 300
    GeoffW283
    05-10-2019, 10:51 AM Go to last post

  8. Pull specific info for a range of cells

    Started by balucanb‎, 05-10-2019 10:30 AM
    1 Attachment(s)
    • 1
    • 280
    Sam Capricci
    05-10-2019, 10:43 AM Go to last post

  9. I cannot figure out what is wrong with this formula. Help Please?

    Started by lupinedusk‎, 05-10-2019 09:43 AM
    • 9
    • 297
    Sam Capricci
    05-10-2019, 10:23 AM Go to last post

  10. [SOLVED] return values based on multiple >< ranges

    Started by donald83‎, 05-10-2019 09:33 AM
    1 Attachment(s)
    • 3
    • 245
    Sam Capricci
    05-10-2019, 09:55 AM Go to last post

  11. Using index match to lookup and align data

    Started by mightybracket123‎, 05-09-2019 11:38 AM
    2 Attachment(s)
    • 9
    • 384
    José Augusto
    05-10-2019, 09:22 AM Go to last post

  12. Find repeating values across multiple datasets

    Started by tm.winkler‎, 05-10-2019 06:13 AM
    #count, #duplicate, #multipleselections 2 Attachment(s)
    • 1
    • 281
    canapone
    05-10-2019, 09:18 AM Go to last post

  13. Print in PDF based on selection of one or more if possible at Path Local incl cloud drive

    Started by paradise2sr‎, 05-10-2019 08:45 AM
    1 Attachment(s)
    • 0
    • 262
    paradise2sr
    05-10-2019, 08:45 AM Go to last post

  14. Assigning a value to a word

    Started by drexcel7‎, 05-10-2019 05:58 AM
    • 3
    • 416
    TMS
    05-10-2019, 07:50 AM Go to last post

  15. Loan Amortization question

    Started by needhelp13‎, 05-09-2019 12:43 PM
    3 Attachment(s)
    • 1
    • 224
    tim201110
    05-10-2019, 06:53 AM Go to last post

  16. help needed with inputting more conditions into this IF formula

    Started by terry3218‎, 05-08-2019 11:49 PM
    1 Attachment(s)
    • 2
    • 264
    Kaper
    05-10-2019, 06:14 AM Go to last post

  17. Eight Smallest Values

    Started by Snoddy1994‎, 05-10-2019 03:20 AM
    • 2
    • 259
    avk
    05-10-2019, 05:48 AM Go to last post

  18. Question Find sum of difference in a single column based on criterias.

    Started by ankitpsaraogi‎, 05-09-2019 02:34 PM
    array, formula, sumif 4 Attachment(s)
    • 2
    • 529
    ankitpsaraogi
    05-10-2019, 04:14 AM Go to last post

  19. Inventory Tracker Help

    Started by SethE0531‎, 05-08-2019 10:33 PM
    4 Attachment(s)
    • 5
    • 502
    KOKOSEK
    05-10-2019, 04:12 AM Go to last post

  20. [SOLVED] From Arabic word to English Word - Transliternation

    Started by rameshantony2000‎, 05-09-2019 12:06 PM
    exccel function, formula and if statement, word copy separate tables 1 Attachment(s)
    • 1
    • 386
    Keebellah
    05-10-2019, 02:24 AM Go to last post

  21. [SOLVED] Formula for converting a date to quarter and leaving blank cell for no date values

    Started by jayc2111‎, 01-14-2013 02:39 PM
    1 Attachment(s)
    • 4
    • 3,558
    Jayda
    05-10-2019, 12:57 AM Go to last post

  22. How To Convert Excel formula Sheet Or Cells To Html Table ?

    Started by munna418‎, 05-10-2019 12:18 AM
    • 1
    • 687
    AliGW
    05-10-2019, 12:52 AM Go to last post

  23. [SOLVED] Index Match - how to bring the value of one cell to multiple reference cells

    Started by jairjacom‎, 05-02-2019 03:23 PM
    2 Attachment(s)
    • 7
    • 465
    JeteMc
    05-10-2019, 12:49 AM Go to last post

  24. [SOLVED] Restrict values in dropdown list by IF and Lookup Formulas

    Started by mjlhyj‎, 05-06-2019 08:31 AM
    3 Attachment(s)
    • 7
    • 470
    JeteMc
    05-10-2019, 12:10 AM Go to last post

  25. [SOLVED] Auto Filter and Sum Results (Material Filter and Optimser)

    Started by Ross82‎, 05-06-2019 03:23 AM
    3 Attachment(s)
    • 5
    • 411
    JeteMc
    05-10-2019, 12:07 AM Go to last post

  26. Data Validation to stop using certain characters

    Started by Jr66‎, 05-06-2019 11:57 AM
    • 4
    • 311
    FDibbins
    05-10-2019, 12:06 AM Go to last post

  27. [SOLVED] Create a search box and duplicate fuction

    Started by brad2018‎, 05-09-2019 05:07 PM
    1 Attachment(s)
    • 3
    • 255
    jeffreybrown
    05-09-2019, 09:20 PM Go to last post

  28. adding and subtract hours and minutes with 5 digit hours

    Started by emiliopena2‎, 05-08-2019 03:46 PM
    1 Attachment(s)
    • 4
    • 1,448
    Pete_UK
    05-09-2019, 08:44 PM Go to last post

  29. Question Pulling info from 2 different tabs

    Started by ern1967‎, 05-09-2019 04:00 PM
    1 Attachment(s)
    • 3
    • 415
    alansidman
    05-09-2019, 07:04 PM Go to last post

  30. [SOLVED] VLookup, If, And... but how to look somewhere else if FALSE?

    Started by JennOlsen‎, 05-09-2019 02:35 PM
    2 Attachment(s)
    • 8
    • 1,116
    JennOlsen
    05-09-2019, 06:51 PM Go to last post

  31. Unique Identifier for Certain Criteria - PART 2

    Started by rosetc16‎, 05-09-2019 03:30 PM
    1 Attachment(s)
    • 9
    • 301
    Melvosh
    05-09-2019, 05:47 PM Go to last post

  32. Google Sheets query function replacement

    Started by Ollie Frith‎, 05-09-2019 09:05 AM
    1 Attachment(s)
    • 3
    • 1,268
    Melvosh
    05-09-2019, 05:41 PM Go to last post

  33. how to use Offset in array formula to avoid #ref issue

    Started by barman‎, 05-09-2019 02:32 PM
    • 1
    • 371
    BlindAlley
    05-09-2019, 03:16 PM Go to last post

  34. Counting Hours Worked Excluding Public Holidays

    Started by Joeyhoyw‎, 05-09-2019 12:13 PM
    1 Attachment(s)
    • 1
    • 215
    ben_hensel
    05-09-2019, 03:07 PM Go to last post

  35. Colour of cell represents certain value in formula?

    Started by nmsmith‎, 05-09-2019 12:25 PM
    • 1
    • 235
    ben_hensel
    05-09-2019, 02:49 PM Go to last post

  36. Find data in over 100 excel files

    Started by jad007‎, 05-08-2019 05:56 PM
    • 12
    • 399
    jad007
    05-09-2019, 02:14 PM Go to last post

  37. [SOLVED] Using SUMPRODUCT to Extract #'s from mid String including Zero's

    Started by BlindAlley‎, 05-09-2019 12:37 PM
    1 Attachment(s)
    • 3
    • 722
    BlindAlley
    05-09-2019, 02:13 PM Go to last post

  38. Question [SOLVED] SUMPRODUCT help needed to calculate rate (requires brain of a genius)

    Started by Flora20‎, 05-09-2019 08:57 AM
    excel, formula, sumproduct 2 Attachment(s)
    • 5
    • 479
    Flora20
    05-09-2019, 02:12 PM Go to last post

  39. Looking to Create Consecutive IDs based on Criteria

    Started by rosetc16‎, 05-09-2019 12:30 PM
    excel, formula, ids, unique 1 Attachment(s)
    • 1
    • 748
    Pete_UK
    05-09-2019, 01:28 PM Go to last post

  40. [SOLVED] Return MAX result for specific criteria for multiple values

    Started by Melchizedek‎, 05-04-2019 04:25 PM
    1 Attachment(s)
    • 5
    • 497
    JeteMc
    05-09-2019, 01:13 PM Go to last post

  41. Three Level Nested Time Calculation IF Statement

    Started by TheCarsForever‎, 05-08-2019 11:42 AM
    date & time calculation, formula, nested if, time
    • 4
    • 569
    TheCarsForever
    05-09-2019, 12:36 PM Go to last post

  42. [SOLVED] Extracting number from text, no consistency on where number is located in text

    Started by yamalady‎, 05-09-2019 11:57 AM
    • 3
    • 475
    AlKey
    05-09-2019, 12:17 PM Go to last post

  43. [SOLVED] Resource calculator

    Started by JimmerB‎, 04-24-2019 11:51 AM
    4 Attachment(s)
    • 5
    • 449
    JimmerB
    05-09-2019, 11:53 AM Go to last post

  44. [SOLVED] COUNTIF by week based on starts with

    Started by chuttus‎, 05-07-2019 04:23 PM
    1 Attachment(s)
    • 12
    • 351
    GeoffW283
    05-09-2019, 11:44 AM Go to last post

  45. Count Function Occurrence No Duplicates

    Started by excelCEC1234‎, 05-08-2019 03:45 PM
    1 Attachment(s)
    • 1
    • 331
    XLent
    05-09-2019, 10:29 AM Go to last post

  46. VLOOKUP to compare the values of two worksheets

    Started by Ladyloo‎, 05-09-2019 10:03 AM
    • 1
    • 200
    Pete_UK
    05-09-2019, 10:16 AM Go to last post

  47. [SOLVED] Lookup cell value based on multiple criteria

    Started by cherias‎, 05-06-2019 11:50 AM
    combo box dynamic link, formula, index & match, scroll bar 8 Attachment(s)
    • 10
    • 551
    kvsrinivasamurthy
    05-09-2019, 10:14 AM Go to last post

  48. Formula to match cell value to range of values

    Started by zarize92‎, 05-09-2019 09:30 AM
    1 Attachment(s)
    • 8
    • 216
    jeffreybrown
    05-09-2019, 09:57 AM Go to last post

  49. [SOLVED] Extract Rows of data to new Sheet

    Started by KrysBTrying‎, 04-15-2019 03:43 PM
    2 Attachment(s)
    • 5
    • 593
    JeteMc
    05-09-2019, 08:31 AM Go to last post

  50. Automatically populate forward planner based on interval

    Started by mobileangusAIM‎, 05-09-2019 07:38 AM
    • 1
    • 221
    Pete_UK
    05-09-2019, 07:43 AM Go to last post
+ Post New Thread
Page 949 of 5615 FirstFirst ... 949 ...

Forum Information and Options

Users Browsing this Forum

There are currently 65 users browsing this forum. (6 members & 59 guests)

  1. Extrudius,
  2. Lafsen,
  3. ohitsadonkey,
  4. RaulSerg,
  5. windknife

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