|
Multiple-Dual-Validations
Here is the project for the lesson in the same name Open Lesson.
It is to demonstrate how to do multiple validations in the same sheet, or as we want to ...
details
|
|
Views: 580
|
|
Downloads: 63
|
|
UI: En
|
|
Since: 5/14/2009
|
|
|
Convert Two-columns-table to Column-Row-table
This Excel file will convert a table of two columns into a Column-Row table
Using functions only and auto-updated once the Main table update
I needed this one few days ago and yYou will ...
details
|
|
Views: 270
|
|
Downloads: 39
|
|
UI: En
|
|
Since: 4/15/2009
|
|
|
Convert CamelCase to Title Case (Adding spaces)
It is all in formulas. Put additional spaces before any upper case letter. made specially for custom request. using functions LEFT, MID, FIND, SMALL, COUNT, COLUMN, IF, CHAR, ISERROR, ...
details
|
|
Views: 333
|
|
Downloads: 67
|
|
UI: En
|
|
Since: 3/31/2009
|
|
|
Using HyperLink function and more
Here is the file that a lot were asking me to do
It has the using of HYPERLINK function along with CELL and MID to create Hyperlinks to differant types of cells, Cell in the same sheet, same in ...
details
|
|
Views: 298
|
|
Downloads: 70
|
|
UI: En
|
|
Since: 2/28/2009
|
|
|
Tally Chart in functions
This is a small Excel 2003 file, that shows you how to do a Tally Chart using pure functions only
the chart will be auto updated once the source is ...
details
|
|
Views: 340
|
|
Downloads: 67
|
|
UI: En
|
|
Since: 1/31/2009
|
|
|
Zip Code Search function
Enter a zip code, and Excel will tell you in which state it is
It also has a list of all zip codes for all states and a technique (INDEX and MATCH functions) to get the state from a given zip ...
details
|
|
Views: 239
|
|
Downloads: 56
|
|
UI: En
|
|
Since: 1/30/2009
|
|
|
Progress bar in functions
This file will show you how you can draw a simple progress bar using functions.
You can select the major value and the current value, once any of them changed the progress bar will show you how ...
details
|
|
Views: 221
|
|
Downloads: 60
|
|
UI: En
|
|
Since: 1/26/2009
|
|
|
Delete Rows
Delete rows from a table using formulas, or Read every other row from a column, or also used to convert one column into two columns, one with odd, and one with even cells
details
|
|
Views: 266
|
|
Downloads: 58
|
|
UI: En
|
|
Since: 1/23/2009
|
|
|
Block converter
Convert cell with block text (More than word) into word each cell based on the spaces ...
details
|
|
Views: 241
|
|
Downloads: 40
|
|
UI: En
|
|
Since: 1/17/2009
|
|
|
Weekly Calendar
Weekly calendar (functions only, no VBA or macros) to those of you who needed that
It has three sheets, one for this week (The date of today), one for next week, and the third one is for the ...
details
|
|
Views: 361
|
|
Downloads: 79
|
|
UI: En
|
|
Since: 12/31/2008
|
|
, 
