+ Post New Thread
Page 21 of 5614 FirstFirst ... 21 ...
Threads 1001 to 1050 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. [SOLVED] Formule to show multiples of 1 cel only

    Started by Peter27‎, 03-01-2024 06:46 AM
    3 Attachment(s)
    • 9
    • 204
    ByteMarks
    03-05-2024, 01:32 PM Go to last post

  2. [SOLVED] YTD sum based on selection of month - financial year April to March

    Started by vijayca‎, 03-04-2024 12:14 PM
    1 Attachment(s)
    • 4
    • 119
    vijayca
    03-05-2024, 10:40 AM Go to last post

  3. Pay Rates against True Time

    Started by DKILG‎, 02-20-2024 05:56 AM
    pay, payroll, penalty rates 2 Attachment(s)
    • 6
    • 269
    JeteMc
    03-05-2024, 10:00 AM Go to last post

  4. [SOLVED] Extract value based on 2 conditiond

    Started by kmsalehi‎, 03-05-2024 09:35 AM
    2 Attachment(s)
    • 3
    • 126
    AliGW
    03-05-2024, 09:50 AM Go to last post

  5. [SOLVED] Countifs and averageifs

    Started by Yoni17‎, 03-05-2024 03:04 AM
    5 Attachment(s)
    • 21
    • 201
    AliGW
    03-05-2024, 09:09 AM Go to last post

  6. [SOLVED] linking and deleting cell data.

    Started by alan2260‎, 03-04-2024 06:09 AM
    2 Attachment(s)
    • 9
    • 162
    DJunqueira
    03-05-2024, 08:25 AM Go to last post

  7. [SOLVED] Excel doesn't recognize data as number

    Started by Zewa‎, 03-04-2024 02:37 PM
    2 Attachment(s)
    • 7
    • 203
    DJunqueira
    03-05-2024, 07:49 AM Go to last post

  8. [SOLVED] Automatic move data in table

    Started by eriol.fx‎, 03-04-2024 11:24 PM
    2 Attachment(s)
    • 4
    • 150
    DJunqueira
    03-05-2024, 07:38 AM Go to last post

  9. [SOLVED] `N' inside `SUM' Formula help required to understand

    Started by Sekars‎, 03-05-2024 05:08 AM
    • 3
    • 101
    Sekars
    03-05-2024, 05:33 AM Go to last post

  10. Seperation of date from one column to multiple

    Started by GULSHAN KUMAR ARORA‎, 03-05-2024 04:21 AM
    • 1
    • 62
    AliGW
    03-05-2024, 04:28 AM Go to last post

  11. Help with creating a formula to compare data between sheets

    Started by Calvo‎, 03-04-2024 11:30 AM
    2 Attachment(s)
    • 3
    • 131
    AliGW
    03-05-2024, 04:27 AM Go to last post

  12. Post [SOLVED] Find MIN(lowest value) ONLY after MAX(Highest value) is found in a range of data.

    Started by DEANH123‎, 02-26-2024 05:16 AM
    4 Attachment(s)
    • 16
    • 292
    AliGW
    03-05-2024, 04:01 AM Go to last post

  13. Excel Simple (ish) Packing Problem

    Started by conor.sinnott‎, 03-04-2024 11:04 PM
    1 Attachment(s)
    • 1
    • 176
    AliGW
    03-05-2024, 01:54 AM Go to last post

  14. Automatically populate one cell based on information from another cell using dropdowns

    Started by gr8teful‎, 03-04-2024 08:30 PM
    1 Attachment(s)
    • 3
    • 120
    TMS
    03-05-2024, 01:13 AM Go to last post

  15. Trying to highlight the fourth Monday of my excel yearly calendar. Need Help!

    Started by clrockwell15‎, 03-04-2024 04:26 PM
    • 5
    • 138
    Rick Rothstein
    03-04-2024, 10:45 PM Go to last post

  16. lMultiple IF, Functions

    Started by HuttoBear‎, 03-04-2024 05:28 PM
    • 3
    • 103
    TMS
    03-04-2024, 05:57 PM Go to last post

  17. +30 days from today

    Started by tricky 1-1‎, 02-28-2024 06:04 PM
    • 5
    • 176
    Rick Rothstein
    03-04-2024, 05:54 PM Go to last post

  18. [SOLVED] Taking weekly data and converting to monthly

    Started by dc007c0231‎, 02-28-2024 12:17 PM
    formula, sumproduct 3 Attachment(s)
    • 10
    • 335
    JeteMc
    03-04-2024, 05:04 PM Go to last post

  19. [SOLVED] Changing from AVERAGEIFS to AGGREGATE using EMONTH function

    Started by Dbroek‎, 03-04-2024 03:55 PM
    • 5
    • 128
    Fluff13
    03-04-2024, 04:56 PM Go to last post

  20. [SOLVED] Generate every value between two values (letters and numbers)

    Started by benexclaimed‎, 07-05-2019 11:31 AM
    2 Attachment(s)
    • 8
    • 1,204
    AliGW
    03-04-2024, 04:54 PM Go to last post

  21. Dynamic Range with Dates

    Started by misjonarka‎, 03-01-2024 12:49 PM
    3 Attachment(s)
    • 9
    • 282
    DJunqueira
    03-04-2024, 03:15 PM Go to last post

  22. Count dupblicate values and return these values

    Started by olga6542‎, 03-04-2024 01:37 PM
    2 Attachment(s)
    • 1
    • 118
    dflak
    03-04-2024, 02:42 PM Go to last post

  23. Pulling data from multiple Excel Sheet

    Started by Jenish91‎, 03-04-2024 10:22 AM
    3 Attachment(s)
    • 5
    • 176
    Bernie Deitrick
    03-04-2024, 02:26 PM Go to last post

  24. [SOLVED] Lookup to return more than just 1 result.

    Started by Shruder‎, 03-04-2024 02:01 PM
    1 Attachment(s)
    • 4
    • 129
    Fluff13
    03-04-2024, 02:21 PM Go to last post

  25. [SOLVED] Data Transpose from Columns to Rows-Power Query

    Started by Johnyam54‎, 03-04-2024 12:41 PM
    3 Attachment(s)
    • 11
    • 198
    alansidman
    03-04-2024, 02:13 PM Go to last post

  26. Convert Inconsistent HH:MM:SS Formatting to Use 00:00:00

    Started by newoski‎, 03-01-2024 11:13 AM
    3 Attachment(s)
    • 13
    • 272
    Rick Rothstein
    03-04-2024, 11:31 AM Go to last post

  27. Which function should I use?

    Started by evanandrews03‎, 03-04-2024 11:13 AM
    • 2
    • 90
    AliGW
    03-04-2024, 11:19 AM Go to last post

  28. Copy formula down a column only changing column ref

    Started by Linstros‎, 03-04-2024 07:58 AM
    2 Attachment(s)
    • 11
    • 138
    TMS
    03-04-2024, 11:08 AM Go to last post

  29. Wink [SOLVED] Encountering an issue with the sum product formula

    Started by hasan mougharbel‎, 03-04-2024 10:00 AM
    2 Attachment(s)
    • 3
    • 113
    Czeslaw
    03-04-2024, 10:14 AM Go to last post

  30. [SOLVED] =MAX(ROW(Table)) Does not work. help please

    Started by mhmahdi12‎, 03-03-2024 01:01 PM
    max, min, row 7 Attachment(s)
    • 17
    • 293
    DJunqueira
    03-04-2024, 10:04 AM Go to last post

  31. Question Listing Non-Blank Cells

    Started by APLACIDO15‎, 03-01-2024 12:25 PM
    non-blank formula, non-blanks
    • 7
    • 124
    DJunqueira
    03-04-2024, 08:13 AM Go to last post

  32. Search

    Started by babylock99‎, 03-03-2024 10:01 PM
    2 Attachment(s)
    • 7
    • 189
    DJunqueira
    03-04-2024, 08:03 AM Go to last post

  33. [SOLVED] how to display data in a cell that has the most appearances in a column

    Started by stone1048‎, 03-03-2024 06:02 PM
    pro plus 2019
    • 6
    • 168
    stone1048
    03-04-2024, 07:38 AM Go to last post

  34. [SOLVED] GROUPBY does not SUM the entire array provided

    Started by dxfoxd‎, 03-03-2024 07:32 PM
    groupby 5 Attachment(s)
    • 6
    • 212
    DJunqueira
    03-04-2024, 06:56 AM Go to last post

  35. Issue with Drop down Box

    Started by Eric Tsang‎, 03-04-2024 05:51 AM
    3 Attachment(s)
    • 3
    • 90
    AliGW
    03-04-2024, 06:15 AM Go to last post

  36. [SOLVED] How to Transform Horizontal Data with Merged Headers to a Vertical Format

    Started by Waqas Gul‎, 03-02-2024 06:13 AM
    7 Attachment(s)
    • 13
    • 319
    JohnTopley
    03-04-2024, 05:15 AM Go to last post

  37. How to get the right date behind the right name based on today from anoher sheet

    Started by Excellerend‎, 02-20-2024 07:34 AM
    date, schedule 1 Attachment(s)
    • 3
    • 146
    TMS
    03-04-2024, 05:04 AM Go to last post

  38. [SOLVED] How to use reverse writing of numbers from top to bottom

    Started by choletseng‎, 03-03-2024 01:43 AM
    5 Attachment(s)
    • 14
    • 305
    FDibbins
    03-04-2024, 12:57 AM Go to last post

  39. [SOLVED] Formula help to reflect value in table 1 from table 2 in same row matching criteria

    Started by vijayca‎, 03-03-2024 12:30 PM
    4 Attachment(s)
    • 7
    • 186
    DJunqueira
    03-03-2024, 11:41 PM Go to last post

  40. Question Sumifs between times

    Started by bobbybrown24‎, 03-03-2024 10:50 PM
    sumifs
    • 3
    • 94
    Sam Capricci
    03-03-2024, 11:39 PM Go to last post

  41. Question [SOLVED] FILTER range only if cells in a range are not empty

    Started by qadeerahmed‎, 03-03-2024 12:08 AM
    excel & formula, excel 2021, formula and functions 7 Attachment(s)
    • 17
    • 377
    wk9128
    03-03-2024, 09:37 PM Go to last post

  42. [SOLVED] Conditional formatting highlighting if cell doesn't contain 2 numbers

    Started by rhayes23‎, 03-03-2024 07:05 PM
    • 5
    • 98
    TMS
    03-03-2024, 08:08 PM Go to last post

  43. [SOLVED] Array bogging down CPU

    Started by Bad Idea Fairy‎, 03-03-2024 11:07 AM
    3 Attachment(s)
    • 7
    • 157
    AliGW
    03-03-2024, 07:54 PM Go to last post

  44. Populate an amount into the correct column based on a weekly paycheck

    Started by AlexG80‎, 03-02-2024 10:25 AM
    6 Attachment(s)
    • 12
    • 293
    MohamedGadAllah
    03-03-2024, 05:57 PM Go to last post

  45. Scientific Calculator formula VS Excel different answers

    Started by Blastfurnace‎, 03-03-2024 01:21 PM
    1 Attachment(s)
    • 1
    • 131
    Pete_UK
    03-03-2024, 01:31 PM Go to last post

  46. Vlookup fomula is not working

    Started by Mofasol‎, 03-02-2024 12:14 PM
    2 Attachment(s)
    • 8
    • 173
    Fluff13
    03-03-2024, 10:37 AM Go to last post

  47. is there any formula for countif in range?

    Started by lalaarif1‎, 02-29-2024 11:46 AM
    5 Attachment(s)
    • 10
    • 267
    windknife
    03-03-2024, 06:43 AM Go to last post

  48. Need to count number of tiimes same employee with same certification in an excel sheet

    Started by vijavad‎, 03-03-2024 05:35 AM
    2 Attachment(s)
    • 5
    • 115
    AliGW
    03-03-2024, 06:20 AM Go to last post

  49. [SOLVED] Better way to write formulas with TEXTBEFORE and TEXTAFTER?

    Started by JN831‎, 03-03-2024 04:37 AM
    1 Attachment(s)
    • 10
    • 136
    AliGW
    03-03-2024, 05:02 AM Go to last post

  50. [SOLVED] Formulas for showing cocktail ingredients for a particular from a lsit on another sheet

    Started by amar87‎, 09-25-2022 12:13 AM
    formula; vlookup 4 Attachment(s)
    • 7
    • 332
    AliGW
    03-03-2024, 03:14 AM Go to last post
+ Post New Thread
Page 21 of 5614 FirstFirst ... 21 ...

Forum Information and Options

Users Browsing this Forum

There are currently 38 users browsing this forum. (1 members & 37 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