Excel Worksheet Functions - Page 505

Thread / Thread Starter	Last Post	Replies	Views
What Function Will Get Me The Result I Need [email protected]	by joeu2004[_2_]	3	1,308
left, search mid [email protected]	by Claus Busch	3	2,027
Countifs between a certain value [email protected]	by Claus Busch	3	1,385
Need Formula For Extracting Part Numbers tb	by tb	3	1,480
time decision for open file in Excel [email protected]	by [email protected]	3	2,626
CONVERSION OF TEXT TO DATE via135	by wabbleknee	3	1,586
Formula for Win/Lose Streak [email protected]	by Vuko Strugar	3	1,540
Number values CP514	by CP514	3	1,384
FREQUENCY FORMULA rhhince[_2_]	by abmmusic4	3	1,344
If statement to work out time/overtime [email protected]	by MyVeryOwnSelf[_3_]	3	1,711
Using the IF and VLOOKUP Function to calculate the tax rates and tax deducted nerrawsl	by GS[_6_]	3	5,938
Find duplicates w/3 criteria [email protected]	by Claus Busch	3	1,234
Cannot bring out the month & year from a date San[_4_]	by San[_4_]	3	1,033
Returning contents of a cell identified by two logic tests SteveRH	by Claus Busch	3	1,144
Help with time/text format [email protected]	by [email protected]	3	957
Ranking by MS-Excel Function Ivan Peeler	by Ivan Peeler	3	806
Comparison of columns using Conditional Formatting Andrea[_12_]	by MyVeryOwnSelf[_3_]	3	991
Selecting rows. Mandeep Baluja	by Claus Busch	3	1,016
Break Total (SUM question) [email protected]	by GS[_2_]	3	1,430
SUMPRODUCT Unique Values [email protected]	by [email protected]	3	495
Match value in column number received from previous match HÃ¥kan BjÃ¶rkstrÃ¶m	by MyVeryOwnSelf[_3_]	3	459
COUNTIF across multiple tabs in Google Sheets Victoria Emory	by Wilbur Chua	3	1,537
Complex Sumproduct formula Ray Smart	by Claus Busch	3	400
Trying to replace vlookup with xlookup and not using the indirect function George[_35_]	by Harlan Grove[_2_]	3	1,385
Calculate the number of pay periods in a given span ParalegalMP	by Claus Busch	3	486
If, And & Or In Same Formula Jennifer Briles	by Claus Busch	3	808
Help with Sick time accrual formula for pausing when a max is reachedand resuming when time is used Emylie	by MyVeryOwnSelf[_3_]	3	674
Index Match leonard hofstatder	by Claus Busch	3	700
Change conditional formatting if the number is odd or even? [email protected]	by GS[_6_]	3	592
Excel gives me false IRR values\|How do I find the real IRR on this investment LaWhore Mama	by joeu2004[_2_]	3	1,755
Linear weighted regression [email protected]	by Auric__	3	1,099
AVERAGE with multiple conditions AaronR	by Wilbur Chua	3	1,141
Excel spreadsheet formula to count numbers in PivotTable column [email protected]	by GS[_6_]	3	1,495
Comparing Stop Watch Times Curtopia	by Claus Busch	3	1,664
Help with multiple IF Tarlis Machado	by Claus Busch	3	1,345
sum last N rows not being a weekend [email protected]	by [email protected]	3	1,182
Excel POWER Function \| What's the formula for Punjabi Mathematician	by Punjabi Mathematician	3	1,484
Copy Pivot column from one Sheet to Another [email protected]	by Tim Paine	3	1,315
how do I copy and paste a drop down list in excel? Adriana	by ExcelBanter AI	3	29,689
Freeze Panes loss Walter Briscoe	by GS[_2_]	3	391
offset formula causing Circular reference Fighting Illini Mike	by [email protected]	3	3,736
Using countif with multiple criteria mkz	by Wilbur Chua	3	1,566
I want a footnote number (small number) at end of sentence? tallcat4000	by ExcelBanter AI	3	40,388
Convert QuickBooks time format to excel to calculate Misty May	by [email protected]	3	2,394
Compare sheet 1 column A numbers with sheet 2 column A number Not and Excel Expert	by Synkronizer Excel Tool	3	2,193
How do I expand a funtion's maximum character length? eg CUBESET Connie-UTHSCSA	by tomas kopas	3	7,175
Vlookup between two sheets chris	by ExcelBanter AI	3	23,667
Add Seconds to Date - Time Field terminal euphoria	by ExcelBanter AI	3	20,391
Count columns that meet criterias [email protected]	by joeu2004[_2_]	3	501
Productivity Log drew	by ANoline	3	2,969
how to sum multiple matches to a vlookup command LoganTaylin	by ExcelBanter AI	3	25,768
Need a Static Timestamp Formula [email protected]	by [email protected]	3	1,972
SUBTOTAL and COUNTIF (or SUMIF) combination DKS	by Claus Busch	3	4,479
is there a function like NORMSINV for exponential distribution Stuart Douglas[_2_]	by ExcelBanter AI	3	19,738
Can I use 'CONTAINS' in an IF Logical Test? MichaelRobert	by ExcelBanter AI	3	22,310
Average and Round together Grd	by ExcelBanter AI	3	23,598
how do i calculate 20% of a total figure resident	by ExcelBanter AI	3	22,091
Problem formatting dates from CSV file rhhince[_2_]	by bisogun35	3	556
Subtracting based on 2 conditions [email protected]	by [email protected]	3	1,148
Upgrade question Colin Hayes	by joeu2004[_2_]	3	1,742
Need a formula which shows the table.. akinkaraman	by akinkaraman	3	1,897
year cant change [email protected]	by Auric__	3	773
Making a Sheet copy [email protected]	by GS[_2_]	3	555
Limit drop down items based on another cell BDAvs	by Cimjet[_4_]	3	728
Countif or other formula needed for multiple data/critera results cdmartin	by MyVeryOwnSelf[_3_]	3	613
Calculate After hours [email protected]	by Claus Busch	3	583
EXCEL ERROR - series formula is too long BobY	by ExcelBanter AI	3	20,927
Cells not updated automatically CS Chia	by GS[_2_]	3	766
Match issue Sking	by Sking	3	631
Finding location (or start cell) of highest consecutive values Emilio Guerra	by Emilio Guerra	3	665
Multiple arguments Tim S	by Ron Rosenfeld[_2_]	3	755
add hyperlink using sheet names and cells(i,j) tuli	by Claus Busch	3	606
Need a ) somewhere in ISERROR formula but don't know where to put it [email protected]	by Claus Busch	3	401
Conditional formatting dates FEVOOO	by Lisa Wilke-Thissen	3	548
lookup vaules which are not exist in a table [email protected]	by [email protected]	3	502