Excel Worksheet Functions - Page 11

Thread / Thread Starter	Last Post	Replies	Views
Sumifs referring to columns defined by header HÃ¥kan BjÃ¶rkstrÃ¶m	by Roger Govier[_11_]	2	985
Insert date in cell when first edit workbook - no change after [email protected]	by GS[_6_]	1	739
Add colon to time automatically, still recognize it as time [email protected]	by Auric__	1	875
formatting numbers as 1st 2nd Bob Arnett	by Auric__	16	4,506
Count If value is greater than 12 and within the past 30 days Vanessa Sales	by Claus Busch	1	624
Use cell content (example: ="a") in formula. R0nald	by Auric__	1	766
Lock Cell After Data is Entered on Particular Cell Moideen	by [email protected]	18	6,498
=IF [email protected]	by [email protected]	2	1,083
Need a code which can search specific hotel adress in google crazy vedios on	by Sunil V	4	667
Calendar cell format beanacrz	by Auric__	1	780
Excel Macro: Type mismatch (Error 13) tb	by GS[_6_]	16	2,644
Index Match leonard hofstatder	by Claus Busch	3	805
Google Sheets - Help formatting Column based on values in another column. [email protected]	by GS[_6_]	1	766
Help formatting Column based on values in another column. [email protected]	by GS[_6_]	1	685
Pivot Table Label Filter [email protected]	by [email protected]	0	790
Overages and Shortages Averi	by Auric__	1	5,111
INDIRECT.EXT function, PULL function [email protected]	by [email protected]	0	1,768
Lock Each Cell After Edit Faizan Khan	by GS[_6_]	1	627
Change conditional formatting if the number is odd or even? [email protected]	by GS[_6_]	3	677
Calculating Weighted Average excluding blanks [email protected]	by Jianguo Li	2	733
SUMIF across multiple worksheets triffidbook	by Auric__	9	1,507
Sort Rows Left To Right tb	by Daniel Choi	1	877
Date Formula results in a #VALUE! Error [email protected]	by [email protected]	2	1,264
NOT equal to Neon520	by Claus Busch	9	1,946
Nested conditionals and VLOOKUPs do not deliver correct resultagainst known manual calculation SanDiegoGuy	by SanDiegoGuy	2	566
Excel Formula (Not Macro) For Sorting By Row tb	by tb	9	762
The time should fall in between the shift timings only [email protected]	by GS[_6_]	1	560
How to add a bookmark to a chart (a big one, not a chart in a sheet) Pierre[_22_]	by GS[_6_]	1	682
Excel97 hangs after startup Wendelin Uez	by Wendelin Uez	0	727
SUMPRODUCT Unique Values [email protected]	by [email protected]	3	562
Calculate the amount of months between two dates and the days in percentage David C[_4_]	by [email protected]	2	677
vlookup formula for my enrollment database [email protected]	by GS[_6_]	1	833
Using Sum function dynamically [email protected]	by [email protected]	4	606
CONDITIONAL FORMATTING BASED ON A DIFFERENCE IN DAYS BETWEEN TWO DATES [email protected]	by [email protected]	1	790
Converting Days:Hours:Minutes:Seconds into Hours:Minutes [email protected]	by Claus Busch	1	515
SUMIFS with multiple criteria provides wrong result GijsKijlstra	by GijsKijlstra	5	1,152
Need help with Excel auto fill dates [email protected]	by MyVeryOwnSelf[_3_]	1	640
Help with calculating time elapsed Jooniper	by Claus Busch	1	656
Need help creating a formula that automatically reallocates unspent funds Wangs930	by Wangs930	4	1,011
Help please, this is driving me mad! Steve[_124_]	by Steve[_124_]	9	875
Find free desk from a list Steve[_124_]	by Steve[_124_]	8	882
Formula for Date Recognition FrequentTraveler	by FrequentTraveler	0	671
Is there a reverse to RANK? [email protected]	by GS[_6_]	1	639
Man hours calculation Mama Mia	by [email protected]	7	5,193
String manipulation Stephan Bird	by Claus Busch	4	1,083
Best function to verify if a scanned barcode exists in a column. LUTESLA	by LUTESLA	0	708
Finding what makes up a summed cell in Excel Shannon Ramaswami	by Shannon Ramaswami	0	700
Conditional formatting and If statements [email protected]	by GS[_6_]	1	796
PUT PAGE NUMBER INTO A SPECIFIC CEL? WERNER SLABBERT[_2_]	by [email protected]	2	1,413
Two condition IF [email protected]	by Claus Busch	1	818
IF,AND,OR formula L. Howard	by L. Howard	2	746
Creating an appointment worksheet graeme_706	by graeme_706	0	647
Excel formula to incrementally increase a value by 1 every day [email protected]	by MyVeryOwnSelf[_3_]	1	1,401
Excel97 problem - how to copy sheets and change references Wendelin Uez	by Wendelin Uez	4	677
wildcards in sumproduct functions K1	by [email protected]	10	2,167
SUMPRODUCT with text cells, returns #VALUE GijsKijlstra	by Claus Busch	4	2,069
Conditional format if cell contains formula Jean-Marc	by [email protected]	15	3,741
Filing System [email protected]	by GS[_6_]	1	827
GOOGLE SHEETS NOT BEHAVING CORRECTLY Abz Trainer	by GS[_6_]	1	647
Pivot Table help! [email protected]	by [email protected]	0	646
Converting standard time to military time C.	by [email protected]	9	2,402
Removing Duplicate Names in Single Cell JoannieMaj	by GS[_6_]	10	1,887
I'm not the most articulate when it comes to spreadsheets... pleasehelp! (Trying to figure out how to auto fill a cell based on drop-down inputfrom another cell using a master sheet) [email protected]	by GS[_6_]	1	596
Counting months in a filtered list DerekE	by [email protected]	4	953
COUNTIFS, MULTIPLY BY QUANTITY [email protected]	by [email protected]	2	2,793
Combining data from several sheets Jooniper	by Jooniper	0	698
Randomly Select and Assigning a Class Schedule to records. Gene Haines	by Gene Haines	0	716
split range address into individual cell addresses noname	by [email protected]	10	3,287
Problems with Match function [email protected]	by gmail_gia_re	1	889
formula that copies the formula of a cell in a diffrent spreadsheet. [email protected]	by [email protected]	0	806
Combine sheets into one Eva	by GS[_6_]	17	2,604
Looking for BOOLEAN ALGEBRA functions (specifically XOR) RL Jones	by Auric__	12	2,970
Working Time Night Shifts Jonahs	by Jonahs	0	872
Create a conditional formula that results in another calculation dyrret	by JIMMYT	11	4,824
Fill cells automatically when cleared R0nald	by R0nald	5	1,098