Excel Discussion (Misc queries) - Page 14

Thread / Thread Starter	Last Post	Replies	Views
Converting a date number? Terry Pinnell[_4_]	by Terry Pinnell[_4_]	2	414
turn off scientific notation slugger92	by [email protected]	3	1,950
Year() Calculating as #REF jlclyde	by jlclyde	0	453
How 2 lock row and column delete/add but allow data entry? CC Santa Monica	by [email protected]	8	3,631
Help needed in hanging the default file location for Excel and Word Kirk Bubul[_2_]	by GS[_6_]	7	700
Protect (Lock) Cell Formatting ONLY GraceJean Jones	by [email protected]	11	2,909
In Excel, how do I get blank rows and columns to print? cvfc the dj	by GS[_6_]	9	1,472
Nested IF function (simple) TeKouma	by Milo Bloom	8	1,203
Doing a SAVE Doesn't Save Formatting Changes ? Robert Rose	by Robert Rose	0	444
Blank Sheet with Gridlines Mike Copeland	by [email protected]	14	4,536
Trapped in a cell! [email protected]	by [email protected]	0	607
Print Selected Items in Excel Order Form B. Costa	by Josh Hurley	4	1,546
Check if a number is an integer or not (and using that in an IF) [email protected]	by dpb	2	736
In-Cell Instructions mckillmt	by [email protected]	4	1,635
Count Weekdays and Weekends separate & < a given cell. Milo Bloom	by Milo Bloom	12	2,513
Best way to create a sorting table with non numerical values [email protected]	by zvkmpw	3	767
Auto-sort worksheet by date in column A avshook	by louise987	4	6,605
Office 365 Excel for MAC Number Format GP[_3_]	by dpb	1	720
words in cell keep repeating Hyde Park	by [email protected]	14	6,180
Search Month within date range bosshard	by zvkmpw	2	698
Object Assignments based on coordinates lasonico	by Wally W.	1	952
Calculate birth date from age JP6262AMY	by [email protected]	6	3,197
Need to setup xls to compute and check Vin Digit [email protected]	by GS[_6_]	1	703
Shortcut to show all after filtering? [email protected]	by [email protected]	0	600
placing a reference to a cell in a print header [email protected]	by [email protected]	0	525
Divide a number in one cell into several others UNEVENLY tdi93	by GS[_6_]	3	732
Countif? Milo Bloom	by Milo Bloom	3	807
Trapped in a cell! [email protected]	by [email protected]	0	705
Average of multiple cells across multiple sheets Craig Pyle	by iliace	2	609
Vlookup - Sheet Name in Cell [email protected]	by Roger Govier[_11_]	4	693
Average of different cells ignoring blanks Craig Pyle	by Simon Woodward	4	854
Drop-Down References a Grouped Item - how to populate multiple SoozTX	by Simon Woodward	4	630
Salary structure calculations Manish	by Manish	0	570
Numbers stuck in strings. Does this number belong? jlclyde	by iliace	2	899
replace - with missing numbers (e.g 1-4 = 1, 2,3,4) jlclyde	by iliace	2	721
Function based on colour of cell text? Terry Pinnell[_4_]	by Terry Pinnell[_4_]	2	613
Difference between two times GARYWC	by GARYWC	22	2,930
how do i set them colors to aqua, accent 5, lighter 80% in excel irisheyes1970	by [email protected]	2	6,919
Text keeps repeating in excel cell [email protected]	by iliace	1	847
Comparing columns, need to quickly change what cols being compared jerryz	by jerryz	1	569
How to locate cells with links to other cells/worksheets pedro	by pedro	5	606
1st and 3rd Thursday formula David	by [email protected]	13	2,596
Free Excel Password Recovery Program. xoom7	by sonithfer	7	2,313
Concatenating formulas Wally W.	by GARYWC	2	694
Returning value from single row of filtered table, given the column header Paul Martin - Melbourne, Australia	by Paul Martin - Melbourne, Australia	2	720
Excel treats 1/2 as a date instead of a fraction [email protected]	by [email protected]	0	644
Reposition Cells in a Column based on another user03	by user03	0	564
Formula to identify decimal versus whole numbers moily	by [email protected]	18	6,772
Hyperlink with Mailto, concatenate, from other sheets in the same workbook Billy Allen	by GS[_6_]	1	924
Day & Month reversed when importing text Terry Pinnell[_4_]	by [email protected]	11	2,684
How to locate cells with links to other cells/worksheets pedro	by pedro	1	548
Consolidate On Steroids??? dpb	by GS[_6_]	24	3,367
Wonder if INDIRECT is the right thing to use here...(probably not) [email protected]	by [email protected]	0	581
Pasting text into VBA macro? Terry Pinnell[_4_]	by GS[_6_]	12	2,303
Formatting based on other cells Milo Bloom	by Milo Bloom	0	452
Change macro to formula? Terry Pinnell[_4_]	by Terry Pinnell[_4_]	2	461
2007 Pivot Tbl to Access Conversion Issues LindaSD	by Trains4Trainees	5	3,052
Clean/delete all cells outside of a range GARYWC	by GS[_6_]	16	2,279
Access Database Repair [email protected]	by [email protected]	1	549
Clear/delete all cells outside of a range GARYWC	by GARYWC	0	512
Excel File Recovery Software [email protected]	by [email protected]	2	775
Using a condition with a slope formula DR515	by DR515	0	491
Dragging Cells to Create Ascending Numerical List [email protected]	by [email protected]	0	1,017
Problem with Paste function in a Table in Excel 2010 Desmond Walsh	by dpb	10	1,678
FORMULA HELP Percentage of cells in a Range as Completed [email protected]	by [email protected]	1	559
Cell not displaying as expected Terry Pinnell[_4_]	by Terry Pinnell[_4_]	7	663
How to find percentage of filled cells in one section Kalahari	by [email protected]	3	2,579
Hiding an unintended value jshaner69	by killme2008	4	529
Is a date month between 2 dates scottax34	by killme2008	1	499
Counting Nr of Entries in a Column which are Formatted as Date orText or Number [email protected]	by Jianguo Li	2	478
Coverting Lotus 123 files to use with excel [email protected]	by [email protected]	0	486
Edit Hyperlink dialog crashes Excel 365 Terry Pinnell[_4_]	by Terry Pinnell[_4_]	0	451
Copy/pasting a date in text format? Terry Pinnell[_4_]	by Terry Pinnell[_4_]	3	551
For Claus Bob[_19_]	by Bob[_19_]	0	517
Seeing Data That I Used To Create A Chart: Bottom Bar Doesn't DisplayChart, Sheet, etc. Anymore ? Bob[_19_]	by Claus Busch	1	517