+ Post New Thread
Page 551 of 5614 FirstFirst ... 551 ...
Threads 27501 to 27550 of 280680

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

  1. Creating job schedule for multiple employees from single job list

    Started by MeLoDee‎, 02-08-2021 10:58 PM
    3 Attachment(s)
    • 3
    • 393
    Pete_UK
    02-10-2021, 05:50 AM Go to last post

  2. [SOLVED] How to count just numbers in the second column which are not the same

    Started by zuzwha‎, 02-05-2021 08:01 AM
    9 Attachment(s)
    • 32
    • 942
    Glenn Kennedy
    02-10-2021, 02:47 AM Go to last post

  3. [SOLVED] Vlookup to look up value based on accoun number

    Started by Howardc1001‎, 02-09-2021 10:21 AM
    8 Attachment(s)
    • 8
    • 289
    Howardc1001
    02-10-2021, 01:59 AM Go to last post

  4. Question [SOLVED] how to find the result based on 3 factors?

    Started by emmr‎, 02-09-2021 12:01 AM
    2 Attachment(s)
    • 2
    • 492
    emmr
    02-09-2021, 11:45 PM Go to last post

  5. [SOLVED] VLOOKUP inside IFERROR not working

    Started by amconnel‎, 02-09-2021 08:20 PM
    1 Attachment(s)
    • 4
    • 343
    amconnel
    02-09-2021, 09:56 PM Go to last post

  6. Can you sum within a formula?

    Started by Prud‎, 02-09-2021 05:10 PM
    1 Attachment(s)
    • 6
    • 310
    Adtxc
    02-09-2021, 09:55 PM Go to last post

  7. [SOLVED] =1/COUNTIF($A$2:$A$15,A2) Prevent counting blank cells

    Started by darenferg‎, 02-09-2021 07:16 PM
    1 Attachment(s)
    • 3
    • 277
    TMS
    02-09-2021, 08:30 PM Go to last post

  8. Check if a weekly time interval falls within one of several weekly time intervals in table

    Started by Marbleking‎, 02-04-2021 01:41 PM
    table, time interval 1 Attachment(s)
    • 1
    • 402
    JeteMc
    02-09-2021, 07:49 PM Go to last post

  9. Conditional Format: Cell with date from previous month

    Started by JaoMagbanua‎, 02-05-2021 01:46 AM
    2 Attachment(s)
    • 4
    • 976
    JaoMagbanua
    02-09-2021, 07:44 PM Go to last post

  10. Recurring Dates expressed as a fraction of a month

    Started by bigAld‎, 02-05-2021 11:56 AM
    2 Attachment(s)
    • 6
    • 620
    FlameRetired
    02-09-2021, 07:23 PM Go to last post

  11. [SOLVED] VLOOKUP and averages on different tab

    Started by larrycroucher‎, 02-09-2021 06:09 PM
    1 Attachment(s)
    • 5
    • 303
    AliGW
    02-09-2021, 06:31 PM Go to last post

  12. IF/VLOOKUP - If Vlookup is blank, run IF formula, if still blank, return a blank

    Started by EvolutionJulie‎, 02-09-2021 01:27 PM
    2 Attachment(s)
    • 3
    • 239
    Glenn Kennedy
    02-09-2021, 06:29 PM Go to last post

  13. Question Metric to Determine the Amount of quantity for a certain amount of allocated funds

    Started by cvici‎, 01-28-2021 09:41 AM
    2 Attachment(s)
    • 3
    • 342
    cvici
    02-09-2021, 05:44 PM Go to last post

  14. Post Solving Equations w/ Fractions using Excel

    Started by samdaman91‎, 01-17-2017 12:37 PM
    equations, fractions, solve, variable 2 Attachment(s)
    • 6
    • 2,194
    AliGW
    02-09-2021, 05:40 PM Go to last post

  15. Help In calculation and Filter

    Started by Pearl_022‎, 02-05-2021 09:12 AM
    9 Attachment(s)
    • 34
    • 794
    Pearl_022
    02-09-2021, 05:06 PM Go to last post

  16. Iferror(vlookup) query

    Started by dfarley‎, 02-09-2021 01:22 PM
    2 Attachment(s)
    • 7
    • 278
    Glenn Kennedy
    02-09-2021, 04:16 PM Go to last post

  17. IF loop

    Started by Pokced‎, 02-09-2021 01:38 PM
    3 Attachment(s)
    • 7
    • 388
    Glenn Kennedy
    02-09-2021, 03:04 PM Go to last post

  18. Max of All Iterations of random numbers

    Started by ieumts‎, 02-09-2021 02:47 PM
    2 Attachment(s)
    • 2
    • 193
    Bo_Ry
    02-09-2021, 03:01 PM Go to last post

  19. [SOLVED] Counting up variables based on month

    Started by Shifty58‎, 02-09-2021 01:03 PM
    3 Attachment(s)
    • 2
    • 220
    ChemistB
    02-09-2021, 02:05 PM Go to last post

  20. [SOLVED] Return Unique Sequence of Data

    Started by ieumts‎, 02-08-2021 01:35 PM
    average, name manager, sequence, uniqu 2 Attachment(s)
    • 3
    • 469
    Glenn Kennedy
    02-09-2021, 01:20 PM Go to last post

  21. [SOLVED] How to count rows based on cell value?

    Started by AccountingJ‎, 02-09-2021 11:24 AM
    2 Attachment(s)
    • 5
    • 265
    Bo_Ry
    02-09-2021, 12:56 PM Go to last post

  22. [SOLVED] IF/OR/VLOOKUP? - Depending on what Column C says, how do I look up its value?

    Started by EvolutionJulie‎, 02-05-2021 04:06 PM
    1 Attachment(s)
    • 2
    • 207
    EvolutionJulie
    02-09-2021, 12:54 PM Go to last post

  23. Question Automatic sorting of multiple columns when new data is entered

    Started by QualityCustomz‎, 02-08-2021 10:38 AM
    2 Attachment(s)
    • 5
    • 250
    torachan
    02-09-2021, 12:18 PM Go to last post

  24. Moved: Calculate End Date & Time from Start Date & Time for given Duration

    Started by vigneshslm‎, 02-08-2021 11:39 AM
    •  
    •  

  25. Using excel to rename jpgs

    Started by grim72‎, 02-09-2021 07:27 AM
    image name, jpg rename
    • 6
    • 270
    ByteMarks
    02-09-2021, 11:43 AM Go to last post

  26. SUMPRODUCT Numbers only in a filtered range

    Started by Duncan McKee‎, 02-05-2021 10:39 AM
    ignore text, sumproduct for filtering, sumproduct function 4 Attachment(s)
    • 7
    • 513
    Glenn Kennedy
    02-09-2021, 09:50 AM Go to last post

  27. count all the numbers greater than 49 but less than 100

    Started by arslan.rafaqat.97‎, 02-09-2021 09:06 AM
    • 6
    • 259
    AliGW
    02-09-2021, 09:24 AM Go to last post

  28. [SOLVED] List of nearest locations in a lookup to a given Lat & Long

    Started by CasualDabbler‎, 02-08-2021 05:21 AM
    2 Attachment(s)
    • 9
    • 533
    jackrobston
    02-09-2021, 08:51 AM Go to last post

  29. [SOLVED] Sumif based on 2 criteria from 2 sheets

    Started by judeprem‎, 02-08-2021 03:30 AM
    7 Attachment(s)
    • 13
    • 520
    Glenn Kennedy
    02-09-2021, 08:23 AM Go to last post

  30. [SOLVED] Conditional Formatting between two sheets

    Started by kcfungus‎, 02-09-2021 03:26 AM
    2 Attachment(s)
    • 2
    • 194
    kcfungus
    02-09-2021, 05:05 AM Go to last post

  31. Calculate Research Contributions by Organizations and Countries

    Started by Taisir‎, 02-07-2021 02:02 AM
    4 Attachment(s)
    • 4
    • 269
    Taisir
    02-09-2021, 04:51 AM Go to last post

  32. [SOLVED] Rank with If Formula

    Started by John Vieren‎, 02-09-2021 02:00 AM
    1 Attachment(s)
    • 5
    • 296
    John Vieren
    02-09-2021, 04:38 AM Go to last post

  33. Counting customers by the hour of the day

    Started by dblackwood72‎, 02-07-2021 08:14 PM
    2 Attachment(s)
    • 4
    • 315
    kvsrinivasamurthy
    02-09-2021, 03:41 AM Go to last post

  34. Extracting numbers from a text thread within an array and forming a column

    Started by Muntasib‎, 02-08-2021 08:42 AM
    1 Attachment(s)
    • 3
    • 291
    Muntasib
    02-09-2021, 03:31 AM Go to last post

  35. Unhappy [SOLVED] Extracting start date and end date

    Started by lols888‎, 02-09-2021 03:11 AM
    concantenate, dynamic, maximum, minimum, vlookup 1 Attachment(s)
    • 0
    • 387
    lols888
    02-09-2021, 03:11 AM Go to last post

  36. [SOLVED] Liquidity budgeting tool

    Started by Heyy‎, 02-08-2021 02:33 PM
    1 Attachment(s)
    • 2
    • 388
    Heyy
    02-09-2021, 02:57 AM Go to last post

  37. [SOLVED] Look up and Return using dates

    Started by pmw19800‎, 02-05-2021 08:23 AM
    3 Attachment(s)
    • 6
    • 311
    pmw19800
    02-09-2021, 02:48 AM Go to last post

  38. I need to use a Vlookup, that depends on the date I select to chose the values?

    Started by slock92‎, 02-09-2021 12:07 AM
    1 Attachment(s)
    • 1
    • 227
    AliGW
    02-09-2021, 02:25 AM Go to last post

  39. Thumbs up [SOLVED] Trying to concatenate multipe cells that woudl then build a reference to a named cell

    Started by jshrader‎, 02-08-2021 04:51 PM
    defined cell name 1 Attachment(s)
    • 2
    • 319
    jshrader
    02-08-2021, 11:50 PM Go to last post

  40. [SOLVED] Remove duplicates by using formula

    Started by alferd324‎, 02-08-2021 09:03 PM
    2 Attachment(s)
    • 7
    • 327
    alferd324
    02-08-2021, 11:47 PM Go to last post

  41. [SOLVED] how to change progress into days with conditional formatting

    Started by noelcjf‎, 02-02-2021 08:21 PM
    4 Attachment(s)
    • 10
    • 523
    JeteMc
    02-08-2021, 11:01 PM Go to last post

  42. If, Match, Index - Help ?

    Started by Kattyg261‎, 02-08-2021 09:57 PM
    1 Attachment(s)
    • 2
    • 247
    Kattyg261
    02-08-2021, 10:39 PM Go to last post

  43. Help with formula to identify loss amount and begin cycle again

    Started by maym‎, 02-08-2021 10:30 PM
    1 Attachment(s)
    • 0
    • 270
    maym
    02-08-2021, 10:30 PM Go to last post

  44. having a 2nd and 3rd cascading dropdown list off a first dropdown

    Started by lee-a-michael‎, 02-06-2021 01:50 AM
    5 Attachment(s)
    • 11
    • 564
    kvsrinivasamurthy
    02-08-2021, 09:33 PM Go to last post

  45. Extract Values into Column F if Condition is Met

    Started by bjnockle‎, 02-08-2021 05:18 PM
    2 Attachment(s)
    • 1
    • 460
    Ochimus
    02-08-2021, 09:22 PM Go to last post

  46. [SOLVED] Simple SumIF not summing ??

    Started by Keithhe‎, 02-08-2021 07:55 PM
    1 Attachment(s)
    • 6
    • 304
    TMS
    02-08-2021, 08:24 PM Go to last post

  47. Formatting/Formula Help

    Started by Wildie16‎, 02-08-2021 11:45 AM
    • 2
    • 199
    bjnockle
    02-08-2021, 07:55 PM Go to last post

  48. extracting partial info from a cell Vlookup

    Started by inky123‎, 02-08-2021 04:38 PM
    • 2
    • 287
    bjnockle
    02-08-2021, 07:45 PM Go to last post

  49. [SOLVED] Extract Values Using Left, Right, or Mid Function

    Started by bjnockle‎, 02-07-2021 07:54 PM
    1 Attachment(s)
    • 7
    • 333
    Sam Capricci
    02-08-2021, 07:43 PM Go to last post

  50. [SOLVED] Adding subtotal Function to a Sumifs formula

    Started by onp‎, 02-07-2021 03:31 PM
    1 Attachment(s)
    • 4
    • 298
    onp
    02-08-2021, 06:39 PM Go to last post
+ Post New Thread
Page 551 of 5614 FirstFirst ... 551 ...

Forum Information and Options

Users Browsing this Forum

There are currently 44 users browsing this forum. (1 members & 43 guests)

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