Excel Worksheet Functions - Page 1175

Thread / Thread Starter	Last Post	Replies	Views
Randomly Assign Tasks to employees in a month without repetitions Mukayi Mutsago	by Mukayi Mutsago	0	575
Random generation of employee assignments Blue Max	by Auric__	6	1,410
"Function Not Valid" - Getting Rid of the "@" symbol [email protected]	by Auric__	1	557
Finding cells based on the colour of the text Jacob Cooke-TIlley	by Auric__	1	560
eliminate negative value from normal random number distribution Ahmad	by abdelkader bouchami	5	958
need to input alternate blank rows in spreadsheet Confused from Hertford	by [email protected]	7	1,472
HOW TO SUM EVERY OTHER COLUMN monir alizadeh	by MyVeryOwnSelf[_3_]	2	505
Dynamic SUMPRODUCT Jan Kronsell[_6_]	by Jan Kronsell[_6_]	2	706
creating Multiple If Statements depending on specific cell entry [email protected]	by [email protected]	0	497
How to write a formula to get the maximum Amount of different TEAM directly wk3913	by MyVeryOwnSelf[_3_]	1	482
Sum formula not working SAM HO	by Auric__	1	428
How can we increment 1.9+0.1 and display 1.10 NOT 2.0 using formula ymadi	by Thibaud Taudin Chabot	6	4,165
Excel Error "That function is not valid" Patrick Henry Ewoi	by Patrick Henry Ewoi	0	764
google sheets truncate #characters but full words Phil Delaney	by Phil Delaney	2	547
merge cells disabled how do I enable Gary	by Bernard Etienne Fety	7	4,936
Adding 2 digits of a number together Gabriel C ZX	by MyVeryOwnSelf[_3_]	2	796
Last date edited - in a single cell to be updated every time a sheetis edited. meleady420	by Auric__	5	679
Using IF Function to Recognize Highlighted Cell Blythe Richardson Smith	by Enrique Rivera	1	666
Show value of first non contiguous data Xxer Xxes	by Xxer Xxes	11	1,188
Calculate a sentences width based on lookup Phil Delaney	by jerry_maguire	1	482
count closest empty cells in a row Xxer Xxes	by Xxer Xxes	4	1,024
Get biggest value, then the smaller one Xxer Xxes	by Xxer Xxes	2	360
how do I delete data in a cell without deleting formula? tripy	by Tim Paine	9	5,195
How to make dependent drop down Lists San[_4_]	by Tim Paine	4	751
How can i calculate the first sunday of each month [email protected]	by Tim Paine	1	897
How to unhide column? Lois Corp Secy	by Tim Paine	5	1,601
Linear weighted regression [email protected]	by Auric__	3	1,105
Copy Pivot column from one Sheet to Another [email protected]	by Tim Paine	3	1,316
HOW DO I SEPERATE POSITIVE AND NEGATIVE VALUES FROM A COLUMN FRANK	by Tim Paine	7	6,459
How to filter Unique values from Duplicates San[_4_]	by Tim Paine	7	1,358
Eulier Totient Function David	by ExcelBen	9	6,872
Lambda, Recursion, and Prime Factors ExcelBen	by ExcelBen	2	729
Round date to next half year Mark Sullivan	by Mark Sullivan	2	363
Complex Sumproduct formula Ray Smart	by Claus Busch	3	400
formula to switch last/first name around? Stilla	by Auric__	11	6,148
How do I get a sum from one cell with multiple numbers into another cell Chauncey Gearhart	by Thibaud Taudin Chabot	1	369
Finding the position of the nth item in a list [email protected]	by JOSEP OLIVA	7	944
Sum Data with Multiple Range = Multiple Range Ping_TH_Thamanart Tantisirivit	by Ping_TH_Thamanart Tantisirivit	1	334
Match value in column number received from previous match HÃ¥kan BjÃ¶rkstrÃ¶m	by MyVeryOwnSelf[_3_]	3	461
Changing Numbering into Arabic!!!! Kareem Hamed	by Kareem Hamed	0	320
How hide all Columns based on specific cell data Dilip Ghosh	by Auric__	1	581
IF statement: how do I simply return the calculation in theconditional as one of the outcomes? David Terranova	by MyVeryOwnSelf[_3_]	1	719
Difference in value of a cell in Excel at two different time. PaddyStan	by Auric__	2	354
splitting cells diagonally and filling with color yooper	by Nils Ejlertsson	5	3,891
Formula doesn't work unless hit enter again Bobby	by AST ATY	7	4,216
How to automatic cell lock after data entry iew ho	by Auric__	1	396
Using Forecast Dynamically David Cuthill[_3_]	by David Cuthill[_3_]	1	354
COUNTIF across multiple tabs in Google Sheets Victoria Emory	by Wilbur Chua	3	1,549
Sum only negative numbers in the Sum Range of the SUMIF function Keyrookie	by Wilbur Chua	1	1,105
SUMIF between date range rhhince[_2_]	by Wilbur Chua	1	665
Inverse of COUNTIF?? [email protected]	by Wilbur Chua	1	1,199
AVERAGE with multiple conditions AaronR	by Wilbur Chua	3	1,142
Concatenate with a specific number of spaces Derek M[_2_]	by Wilbur Chua	4	1,142
Multiple Arguments for IF Chelli	by Wilbur Chua	2	996
nested if function tomtic56	by Wilbur Chua	1	1,583
Create a spreadsheet to budget CDH	by Wilbur Chua	1	759
Need Help with an IF function Timothy J	by Wilbur Chua	1	872
Using countif with multiple criteria mkz	by Wilbur Chua	3	1,569
help for simple formula of summary based on input criteria. driller3_banter	by driller3_banter	0	1,175
Grouping cells for sorting worksheet Melinda CK	by Melinda CK	0	594
Find empty cell then insert range in active row Keyrookie	by Keyrookie	1	999
How do I data sort multiple sheets in Excel that are linked with i yojlem	by JenniferRI	2	1,757
sorting tables in differents sheets having different numbers of columns JenniferRI	by JenniferRI	0	492
How to nest functions with SUMIF function in excel Bobito	by MarySunn	5	3,602
Excel find which group of nunbers repeating in multiple columnes georgekapa	by ExcelBanter AI	1	1,908
Splitting underscore formula goku200	by ExcelBanter AI	1	468
Input Box Error Handler Keyrookie	by ExcelBanter AI	1	408
help for a typical basic formula one summary list @ cells B24,B25,B26;B27 driller3_banter	by ExcelBanter AI	1	313
Incrementing cell ref + 9 rows Uncle Spike	by ExcelBanter AI	1	750
Shortcut to refresh format cells susang	by ExcelBanter AI	1	2,037
Reference the same row from another sheet after inserting a new ro Brian	by ExcelBanter AI	1	709
Check to see if a value exists in a list? Pradhan	by ExcelBanter AI	6	83,821
Escalation Formula Joe Gieder	by ExcelBanter AI	6	77,697
How do I set a maximum value (e.g. cap at 200) LeeLobb	by ExcelBanter AI	8	63,147
How to verify that 3 cells are equal Scott	by ExcelBanter AI	6	54,003