PDA

View Full Version : Microsoft Excel Worksheet Functions


Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 [85] 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160

  1. How do I set up Reminders in an excel spreadsheet?
  2. Dynamic Labels
  3. Position in a string
  4. Comparing 2 pivot tables data using VBA
  5. how do i print filtered rows in Excel?
  6. Newby help
  7. Export XML
  8. "DAYS 360" and the date Feb 28th as start and end
  9. Re: Variable equations help please
  10. Need help on formula
  11. data val
  12. list unique values in a column
  13. End of a Worksheet
  14. How do I count data with criteria from two separate columns in exc
  15. Need help with "if" function in Excel
  16. Need help with "if" function in Excel
  17. How to average one constant # to variable #s? A1:A2 A1:A3 A1:A4
  18. How do you add multiple spreadsheets in to one spread sheet
  19. Lookup Tables and Formulas
  20. pie symbol for math
  21. monthly growth rate
  22. how to get values from different sheet when info. matches?
  23. Possible to change the program Excel uses to open a hyperlinked file?
  24. dsum returns 0 if criteria range too large
  25. how do you set up an if, then formula in excel??
  26. Trying to forecast the future
  27. I can see a worksheet, but I can't type in it or use the tool bar
  28. Sort Groups of Cells
  29. Help with a formula - probably an "IF"
  30. gridline the next page automatically in excel 2003
  31. can you link data from word to excel
  32. Text & Date in the same Cell???
  33. Web Query With Multiple Stock Symbols & Stock Scouter
  34. auto gridline restore after a cut and paste in excell 2003?
  35. Prevent Users from Selecting Cells
  36. Question : Workbooks or Worksheets?
  37. how do I add blank pages to
  38. formula help
  39. convert string to date
  40. index match function help me
  41. Sum Formula that excludes other sum formula in range
  42. $ vs time formula
  43. Pay per hour?
  44. Referencing subtotal numbers
  45. sort in excel that sorts digikey
  46. Is there a maximum number of constraints...
  47. Worksheet Formatting
  48. Returning a blank field
  49. Formula to figure ad schedules
  50. need formula if x<a3<y, value, else
  51. How do I enter like a Word document in an Excel worksheet
  52. Link Worksheets to a Master Sheet
  53. Sum on rows column wise - Strange error
  54. Counting Frequency of Filtered Data
  55. insert rows
  56. Conditional Formatting (IF function)
  57. How do I make it add a column based on 2 different criteria?
  58. Copying information into another workbook
  59. Conditional formatting, simple question...
  60. conditional formatting
  61. Can't get Excel 2003 to open a .wav via hyperlink
  62. Sum help this is puzzling???????????
  63. Conditional formatting
  64. sum with three criteria
  65. MATCH UP DATA IN COLUMNS
  66. Round up to nearest 10
  67. change loan periods in an amortization schedule
  68. Select sheet tabs in workbook & save to separate workbook files
  69. How do I correct error using the =IF(AND(formula in excel?
  70. how do i Count with in the cell range value is >5 and <=15
  71. VLookup Question?
  72. calculation for bank interest chargeable
  73. Default a specific worksheet to be in forefront when open excel?
  74. fancy lookup
  75. VLOOKUP Limitation and Solution?
  76. autocomplete after 4000 entries
  77. Why do gridlines disappear from view when highlighted
  78. Calculate
  79. how do u set up multiple choice answer buttons/dots?
  80. Problem with crystalReportViewer
  81. showing and copying a formula in a cell
  82. Forecasting = loan planning or depreciation??
  83. Countif unique
  84. Microsoft request for slow-calculating workbooks
  85. selecting a worksheet
  86. Work Schedule
  87. incrementing mm/yy based on value in other cell
  88. Find a value in the table cell
  89. ROUND or "Precision as displayed"?
  90. Error message "formula is too long"
  91. locked out of my sheet for read only
  92. VLookup Help???
  93. how to bring an image onto a sheet
  94. Date Sorting
  95. appending and IF statement to an existing IF statement
  96. Hide Rows - copy and paste only rows that show
  97. Determine which column to use by date
  98. Countif Q
  99. Two column value match table look up
  100. Formula to Check Values between to variables
  101. Office 2003 vs. Office 97
  102. not copying correct value
  103. Re: V Look Up Function Problems
  104. Stratify Data In a Range
  105. Re: V Look Up Function Problems
  106. Help with Match Function
  107. how to convert csv format to separet columns in excel
  108. select rows
  109. Scoring/Ranking 2 Columns of Stock Symbols
  110. Extract last name and insert into a different field.
  111. How to display seconds on time stamp?
  112. Miscellaneous
  113. conditional formatting - Highest
  114. Sharing worksheet with a customer toolbar
  115. Why do some Excel cells refer to e-mail?
  116. Linking Worksheets
  117. Can't move between worksheets
  118. Lookup Problem
  119. Sumproduct
  120. forwarding cell data
  121. Countif????
  122. problem using Range Names in VLOOKUP
  123. I'm looking for an advertising layouts for a weight loss programs
  124. Sharing Violation error
  125. Why doesn't the DDB function work all the time?
  126. excel does not open up any workbook
  127. can you assign random numbers to many different lines of row?
  128. how to use cell contents as references in a formula
  129. Copy-Paste sheets - error in the dates
  130. Help With A Macro
  131. Creating a formula by using data in another file
  132. Create Lookup Table
  133. Excel 2002 formula displayed not value formula option not checked
  134. how can i multiply two columns
  135. consolidation of tables in excel with text and figures
  136. Save copy of folder with linked files
  137. VLOOKUP to return first hit
  138. Remove all formatting
  139. excel ?
  140. Formula for Excel
  141. Vlookup show #N/A
  142. Copt data with specific criteria
  143. Calculated Field/Item in a Pivot
  144. Calculated Field in A Pivot
  145. Cannot hide columns in Excel
  146. How to use if statement
  147. Close Dos from Vba?
  148. Rounding Error when adding or subtracting two cells
  149. AVERAGE DAYS OPEN IF BETWEEN DATES
  150. transferring data between 2 worksheets in same workbook
  151. Incrementing numbers
  152. Linking formulas in new sheets based on a template?
  153. pls help again!
  154. common entry reporting
  155. I have more than 6 conditions when using conditional formatting?
  156. Right click help please !
  157. How do I run Excel 95 macros in Excel 2003
  158. Drop-Down List
  159. dates into ages
  160. Complex function....not sure how if the result I want is possible
  161. Reference cell location
  162. Lookup Assistance
  163. Amending an existing function
  164. Is there a formula tutorial online ...............................
  165. How do I sum a range of data (column) that has #num! in some cells
  166. Goal Seel To get Average!?
  167. Using a Text Cell to Reference a Worksheet Name
  168. in excel worksheet, add numbers in column k2&k3
  169. format a drop-down box from a range of cell from another work...
  170. I have lost the in cell drop down in validation
  171. Can this be done with Domain Functions?
  172. Function giving a result for number within a range
  173. only printing certain rows
  174. converting julian day and year to a date?
  175. List info if criteria is met?
  176. range_lookup in lookup functions
  177. Hide previously used items from multiple drop lists
  178. How can I use numbers to define range for Max() ?
  179. Problems with formulas and sorting
  180. how can i view the range of 75% of a column
  181. Subtototal display is in different order than 2002, why?
  182. How can I make the rows go into a random order?
  183. look up functions
  184. Employees
  185. How do I correct error using the =IF(AND(formula in excel?
  186. creating macro working across multiple sheets
  187. hours and minutes multiplied by wage
  188. hours, minutes multiplied by wage
  189. How do I show True as a value in Excel B2 if Cell B1 is bold?
  190. hours multiplied by money
  191. information function - does cell contain reference
  192. Repeat Rows
  193. Dynamic Lists
  194. If Formulas
  195. Searching for mulitple strings and assigning identifying number
  196. IF function, i think??? please help.
  197. Sumproduct with 2 criteria
  198. How can i see on excel feet and inches from decimal system?
  199. Find Formula Problem
  200. sumproduct looking at multiple sheets
  201. How do I do a Reverse Find/Search in Excel?
  202. calculate number of days btw dates
  203. Extract the hour from a cell showing the date and time
  204. How do I protect multiple sheets at one time?
  205. List Box with macro
  206. How do I lock selected cells, so only I can change them?
  207. How do I get multiple matches when using the Vlookup function?
  208. copy sheet with updated dates
  209. assign macro
  210. sumproduct help
  211. how to use spellnumber formula
  212. Count Multiple Criteria
  213. Data validation
  214. Calculation on lookup
  215. counting if two columns contain the same numbers
  216. Forward looking forecast/cover help required
  217. ask 2 function
  218. Get data
  219. MACRO QUESTION
  220. How do I restore column & row cell references
  221. Labels
  222. has anybody come across this before?
  223. Checking Blank Cells
  224. Can function in one cell change value or function in another cell?
  225. Lookup Formula Help - PLEASE!
  226. Formula Help!!!
  227. Returning the last modified date to a cell in excel 2003
  228. Formatting of cells
  229. Is anyone on here with DVS Reporter???
  230. Page Break Problem
  231. pls help
  232. importing on protected sheet?
  233. Help with this formula please!
  234. Accessing the sheetname in a cell
  235. Calculating age.
  236. Looking up a value based on date and time, what's wrong?
  237. Formula to subtract a date from current date
  238. Variable criteria formula
  239. How to prevent copied data from appearing until triggered by anoth
  240. sorting with RANK/VLOOKUP (problem with equal ranks)
  241. Offset Function Trouble, Please Help
  242. Function similar to SHIFT+CTRL+DOWN KEY
  243. Excel references to other sheets
  244. Would like one cell to both count and multiply a range of cells
  245. Is there a better way of doing this?
  246. Lining Tables
  247. find a text - help
  248. Macro Question
  249. getpivotdata
  250. Counting blank cells until value is reached
  251. Date Range for my time sheet
  252. Formula question
  253. Help again please
  254. AVERAGE of the previous meaningful cells
  255. Display 10 records from same workbook but from different sheet
  256. How can I change the color of an "IF" function answer?
  257. Database
  258. Using VLOOKUP with abitlity to choose from multiple defined names.
  259. Can anyone calculate age next birthday from date field?
  260. Nested If statement revisited
  261. Information retrieval functions
  262. How to speed up Autofiltering?
  263. How can I make an excel cell equal to the value of a frame object text box
  264. Nest IF statement workaround
  265. how towrite inside margin
  266. Opening workbooks with names taken from another workbook
  267. cell protection based on a formula
  268. SUMIF
  269. Payroll equation for SS taxes
  270. Excel should automaticaly update a feild when printing ex:Version
  271. Need Help With Formula/Function
  272. How do I identify cells with matching numbers within a column.
  273. Macro - Return to starting cell
  274. Excel Euler function
  275. Find Matching Text In Col A move to Col B
  276. Htperlink in an unlocked cell but protected worksheet
  277. ACCTINTM problems after upgrading to Excel 2003
  278. How can I make an excel cell equal to the value of a text box
  279. Saved spreadsheet - now can't work on it - choices all greyed out
  280. put data from cells into other cells
  281. Counting Data
  282. Transforming Multiple Rows into 2 columns
  283. display a range of data when triggered by a specific condition
  284. I am use (=IF(A2=1,"90") in a few cell i need to then add them up
  285. LOOKUP FUNCTION
  286. Negative Percentage?
  287. auto copy only selected cells
  288. user form question: text box to display result
  289. VLOOKUP False Problem
  290. Multiple accessing of an excel file
  291. insert columns macro is putting 2 columns instead of 1
  292. Re: Run a macro automatically on workbook open
  293. Re: Run a macro automatically on workbook open
  294. pls help me
  295. How to convert VLOOPUP error value #NA to 0?
  296. Need macro to delete all text cells in an Excel range
  297. how do i use a formula count of figures between to conditions
  298. Re: Help with a read only frustration.
  299. Data validation two criteria
  300. Inserting Worksheets
  301. lookup a value and return cells
  302. Calculating sales commision HELP!!!!!!!
  303. Pivot Tables
  304. vlookup with two criteria
  305. What formula would I use?
  306. vlookup with two criteria
  307. Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet
  308. Nesting the SUBSTITUTE formula
  309. return multiple rows of data based on criteria
  310. Command Button protection problems????
  311. Number combinations
  312. Conditional formatting
  313. Can I automaticly figure "cost" and sale price in Excel?
  314. Returning Macro to Starting Cell
  315. Vlookup...
  316. Formula
  317. How can I label a worksheet based on a cell in Excel?
  318. Calculating monthly totals
  319. HELP! Making A Form
  320. how to combine text into a cell???
  321. formatting multiple worksheets
  322. Creating a master worksheet
  323. SumProduct w/WildCard
  324. Saving username into a cell
  325. linkig multiple cells in a pricesheet
  326. SumProduct With Multiple criteria
  327. Creating Array from Pivot Table
  328. sorting data by time and day of week
  329. Sorting with Multiple Rows per Entry
  330. Excel Checkbox can be regconized in a formula and be executed
  331. Formula for counting multiple variables in a spreadsheet
  332. sumif/if with conditions "HELP"
  333. links
  334. How do I change the default shape for comments in Excel?
  335. Returning Macro to Starting Cell
  336. how do i calculate over time per day
  337. Sorting List to a new sheet
  338. calculating the future value of an investment in excel
  339. autocorrect features
  340. Setting up a Macro
  341. How can I use "VLOOKUP" with cells containing both Text & Numbers?
  342. Added up # of cells containing a specified word
  343. Calculating Percentage Rent
  344. how do I format the sheet so that I may click on 1 cell at a time
  345. A function that looks for a value on a sheet on unknown column or row
  346. Why sometimes excel returns error just because function parameters are linked?
  347. Locking a Worksheet
  348. Worksheets/Forms
  349. How do I calcualte APR on Variable Rate Mortgages?
  350. SUMIF across worksheets
  351. Ensure unique solutions to random formula
  352. ISBLANK
  353. How can I prefill a text field with leading 0s?
  354. Counting Errors
  355. Difference between two months
  356. Worksheet name in a cell
  357. Conditional Formatting
  358. How do I set default folder for import
  359. Cell Formatting...
  360. How to show all formula's
  361. How to protect formula's, but allow autofilter
  362. dos from excel vba?
  363. =SUM(($C$1:$C$7>=--"10/01/2004")*($C$1:$C$7<=--"09/30/2005")*(H$1:
  364. INT((MONTH($C$1:$C$7)+2)/3)=$A$2
  365. lookup related with defined name
  366. CANNOT COLOR MY WORKSHEET TABS, TAB COLOR NOT IN FORMAT
  367. writing an "if then" macro
  368. Sum returning 0
  369. how do i concatenate a string and cell formula and use a comma?
  370. problem with replicate formula
  371. wts wrong with this statement
  372. AutoComplete not functioning correctly
  373. where can i find Formulas for excel 2000?
  374. Finding matching cell data
  375. Password protected? help!!
  376. Re: excel vertical function
  377. copying multiple selections
  378. to make a single row record become multiple row records
  379. Properties of a document, help!
  380. Sqlrequest only return one value
  381. error accessing a protected worksheet
  382. Hitting Enter to Move Cursor to the Next Entry Cell
  383. Re: Calculating an average based on 2 and 3 criteria
  384. Return Pay Date
  385. Calculation of instances a value is found in a series of cells
  386. Using last cell in a column that is not empty in a calculation
  387. Nested If Limit
  388. Nested if then else statement
  389. In excel the tabs at the bottom of the page are gone.
  390. dublication
  391. formula starts : =+ what does plus indicate?
  392. Adding a row to worksheet does not update cell references in another.
  393. indirect using name
  394. parsing a cell using |
  395. exchanging values amoung sheets
  396. diverting output
  397. Pivot Table Groups
  398. Concatenate
  399. Excel: How to choose data on two separate rows in the same column
  400. Large Function
  401. Divide a cell by 2 and then add that together
  402. Conditional Formatting
  403. Multi Level Subtotals and SP2
  404. add, multiply then divide
  405. Convert string of digits into a date
  406. how to turn positive to negative values in excel
  407. creating groups based upon correlations
  408. Multiple True's in IF Formula's
  409. Conditional formatting on overtime hours
  410. Copy Sheets Macro
  411. can you rank more than 7 items? how?
  412. How to Sum with two if statements
  413. Urgent date/scheduling calc needed
  414. Row Expansion
  415. Alpha characters problem?
  416. I need help adding cells together?
  417. MESSAGE BOX ON REQUEST
  418. I NEED HELP WITH CONDITIONAL FORMATTING
  419. Sumproduct help
  420. If/cross referencing functions
  421. Adding specific cells in column
  422. Checkbox - Unprotect - How?
  423. Auto Import OR Searching TXT Data
  424. Help with =MOD
  425. Where do I enter the PROPER formula in a spreadsheet?
  426. count number of occurances of a word in a range
  427. countif more than one sheet/tab and sumproduct
  428. Excel color functions
  429. Formatting Question
  430. Rounding
  431. List date adjacent to duplicates?
  432. Worksheets
  433. Sumproduct
  434. Finding Duplicates
  435. delete some cell formulas and leave others using code
  436. Combine functions?
  437. Multiple entries in column
  438. Why does the Pivot table iin Excel add a 2 to my name?
  439. Why is my tab key not working properly any more in Excel?
  440. lookup/vlookup for dates, please help!
  441. Totaling up a column
  442. Format a column wihtout using "Format-Cells-Number-category-etc"
  443. How do I calculate formulas for yes/no data
  444. Make Cells Text
  445. Using a column of data from 1 worksheet to extract data from another worksheet
  446. A weekly equivalent of EOMONTH
  447. Calculating % when 0 is 100%
  448. printing to pdf file
  449. subtraction formula
  450. Formula for area conversation
  451. Message Box to appear Thursday midday!
  452. moving x column values into x row values
  453. macro command
  454. How do I display "Help" Text in my own functions
  455. Formatting #N/A
  456. What if analysis, can this be DONE??
  457. Can I set up a signal in Excel to let me know when my due date is.
  458. i need to find duplicates! ASAP
  459. Throwing Out top & lower percentages
  460. VB and Excel
  461. cell A1=worksheet name
  462. automatic offset cell location when there is a value in a selected cell.
  463. getting data from another spreadsheet
  464. IF function and combo boxes
  465. How can I set up a shortcut key for Autosum?
  466. How do I include a supporting help file for a excel function?
  467. too long sumif help
  468. More help!
  469. Formula creation...if possible
  470. Sort a list with uneven row information
  471. Vlookup always gives me #NA
  472. Complicated If Equation
  473. IF statements and ranges
  474. IF statments and ranges
  475. Password Protecting Sheets in Excel So Others Can't See Certain Sh
  476. Urgent reply would be a great help
  477. selecting values from raw data
  478. Add new button to spreadsheet to print
  479. Formals with IF and Then
  480. vlookup in if
  481. Hide previously used items from multiple drop lists
  482. subtracting time
  483. Outlook 2002 calendar dates exported to Excel 2002 sort incorrectl
  484. create a drop down list
  485. SUMPRODUCT help again!
  486. formula help
  487. Compare cells
  488. Ifs and Ands - I'm confused!
  489. function to reference all of pivottable data field array
  490. pivot table questions
  491. Differentiating data by year into columns
  492. Select all subtotal rows on Pivot Table
  493. my excel formulas are too long to execute find and replace
  494. TRIM formula
  495. I need a little help with comparing columns and indicating the mat
  496. Conditional Formatting in one column using data in two columns
  497. countif question
  498. Help with max() fonction
  499. Formula's
  500. Can you change the function of the fill handle on a cell in Excel
  501. How do I could solve a equation
  502. Formatting Charts from Pivots
  503. set all column formats to Text
  504. Help with formula statament with a MATCH.
  505. How do I set up a cell for blinking due dates
  506. Hyperlink Help Urgent
  507. change sheet name macro
  508. Summary Worksheet from Multiple Workbooks
  509. Creating my own user defined function help statements
  510. Count rows with specific attributes in VBA
  511. =AVERAGE(IF(INT(MONTH(C:C)+2/3)=4
  512. Adding Up cells in one colum IF cell in another column is yes
  513. Hours multiplied by money
  514. Workday function including sat, excluding sun
  515. what if the result of a formula is text
  516. How do you consolidate tables contianing text?
  517. Excell 2000
  518. how do i link to a pivot table to get data dynamically
  519. IF X = Reverse of Y True = 1 False = 0
  520. INDEX then MATCH
  521. "300" notfound?
  522. Urgent help
  523. COLOUR
  524. Increasing number of columns beyond IV
  525. increasing a value everytime excel is opened?
  526. Excel 2000 worksheet is off centered for viewing
  527. function to add or remove
  528. Convert real number to an h:mm:ss display
  529. If 2 cols meet a criteria then sum the 3rd column
  530. Regression intercept to 0
  531. CHITEST worksheet function - bug?
  532. inventory cells
  533. shortcutkey F9
  534. Help with a problem have tried a number of things
  535. Adding dollars
  536. VLookup using 2 worksheets, whole column reference
  537. random numbers
  538. Cannot download exel spreadsheet file with extension type xls
  539. how to group records in a new worksheet
  540. If statements
  541. How do i ignore letters in a formula?
  542. Find value grater than X but less than Y
  543. Using colors outside the standard palette
  544. calculate average for all of data field using GETPIVOTDATA?
  545. Currency to Text
  546. If then with 2 criteria, then sum
  547. =If (need 2 criterias), true, false
  548. Return Totals from Certain Criteria
  549. Adding to Summed Figures
  550. number anagram
  551. Imported Data creates blank cells that aren't really blank
  552. How to create a histogram that updates when I filter the input ran
  553. Colomn of various dates, count & give % of all under 1 year, etc.
  554. Searching a column and returning a yes or no answer
  555. Need assistance: Count non-blank within date range
  556. Mail Merge in Excel
  557. function for finding repeats in a column...
  558. Count non-contiguous cells where value is greater than 0
  559. Formula to Sum Cells that Hold If Formulas
  560. Possible index/match problem?
  561. Find
  562. Cant figure out formula?
  563. updating date!
  564. New rows at the end of a worksheet don't sort with the worksheet
  565. calculating years/months with YEARFRAC?
  566. YEARFRAC formula question
  567. Excel: can I refer to cell reference in page setup header
  568. Calculate Start Dates based on Need-By Date?
  569. Links in multiple worksheet.
  570. Perform calculation from drop down list
  571. Vlookup Question
  572. AVERAGEIF AND SUMIF AND COUNTIF
  573. Commas in indian style
  574. how do i format inserted cells in protected worksheet?
  575. view page breaks
  576. Gray vs Black Lines
  577. dynamic print area
  578. Excel should allow exchange between cells
  579. Formatting to separate dates
  580. Adding A "Timer" to a Macro
  581. Selecting Specific Data within a Table
  582. Text Error Message
  583. search string command to answer simple Yes or No
  584. Re: compare date to column data
  585. Countif
  586. Delete unwanted page breaks.
  587. How validation dropdown list open when cell is picked?.
  588. Sort data into order of product
  589. Umh !
  590. 2 columns
  591. sumproduct help
  592. Counting Dates
  593. How to use miles per hour and mileage to estimate travel time
  594. How do I write the word "sample" across a sheet?
  595. Year and Date Funtions
  596. HELP: excel macro programming woes.... :S
  597. Excel Link Updates
  598. multiple entries-sums to different cells
  599. calculate time periods
  600. Excluding in Excel
  601. Manual Transpose
  602. Custom Footer for each page
  603. Dropdown menu
  604. [excel2003] Compare two rows
  605. [excel 2003] Delete empty rows
  606. how do I Divide "/" a row of cells by another row of cells?
  607. macros
  608. calculating sheets
  609. Print header
  610. how array functions work mmult,minverse etc
  611. How to protect cells from getting deleted or resized?
  612. How can I create a worksheet using Macro
  613. Excel Functions Correl and Pearson are identical
  614. hlp with sumproduct!
  615. Subtotalling
  616. track balance based on payments in Excel
  617. Dividing a time span into shifts - overlapping days
  618. formula in excel to track times between two different dates ?
  619. Column of Text is same as Column of Values
  620. Copying an Array
  621. Can you put two functions in one cell?
  622. unlock hidden rows when 'unhide' is greyed out?
  623. Returning value next to the nth occurrence of a particular number.
  624. LOOKUP FUNCTION
  625. Cell Ref. in Formula changes automatically
  626. How do I set up Reminders in an excel spreadsheet?
  627. SUMIF with AND
  628. HOW TO UPDATE 1 WORKSHEET FROM 2 DIFRENT USERS
  629. How do I merge cells without losing cell values?
  630. Rnage Finder
  631. How do I use a formula to make certain text a different color?
  632. Excel Formula?--> if A1=11am, then D5=A1; if A1=12pm, then D10=A1
  633. how do i get day, date year 1-31 on excel, day=mon
  634. how do i get the sum of data from specific dates
  635. Quote Matrix
  636. ISERROR - #NAME?
  637. Can a formula change a cells colour after a given length of time?
  638. Averaging data that meets a criteria
  639. IF ColumnA = ltr Add Column B
  640. Remove all spaces in a cell...
  641. How do I create a cell reference from a value within a cell?
  642. Just upgraded to excel 2003 and protection is a problem
  643. & help with date format
  644. EXCEL Sheet
  645. How do I create a summary worksheet that references data in other sheets?
  646. Pick from a drop-down list
  647. Time Cell help
  648. FORMULA HELP
  649. What do I call a blank cell?
  650. Pivot table-How to exclude zero values from it.
  651. Auto Save????
  652. Data Entry Form
  653. GETPIVOTDATA returns #REF error
  654. Excel Links Updates in 2003
  655. how do I round 3.30 to the nearest quarter. 3.30=3.25
  656. Formula not converting
  657. How do I display category
  658. Calculating dates - complex scheduling problem
  659. how to split address blocks across multiple cells
  660. settings not saved w/custom view
  661. Combining Digits
  662. Is there a way to save a color palette??
  663. How do I link mulitple drop down boxes together?
  664. pick date from calendar in excel
  665. Aggregate Data from a column in a cell
  666. using list box to edit or select data
  667. countif & and
  668. Iserror question
  669. cells and sheets, names
  670. Basic formula help
  671. Activesync and excel functions
  672. working exemples
  673. How do I replace "#N/A" error, to continue my formula w/o error?
  674. Mofiying the protect option.
  675. Functions
  676. Overcoming "Formula too long"
  677. Excel 2002 worksheet
  678. Urgent - how to set a formula in excel spreadsheet
  679. writing figures in words
  680. How do I use the Color Index to format my cells which requires mo.
  681. Date Formula - in Years
  682. Function fails to calculate
  683. lookup macro??
  684. Random Number
  685. Adding 3 variable formula to a cell
  686. How do I color only half of shape?
  687. Retrieving data from the web - help !
  688. Nested If function?
  689. format a cell if the formula is removed
  690. column addition question
  691. i made a list box but i need to link data to it
  692. Command Button
  693. Code crashes after clearing comments
  694. Pritning 2 selected areas of a sheet
  695. How to determine total value of business for sale
  696. easy way to Consolidate Data within workbook's various worksheets
  697. I am trying to add notes to a drop down list
  698. easy way to Consolidate Data within one workbook's various workshe
  699. Comparing values between columns only when there are values in bot
  700. How do I use a countif function according to two other countif fu.
  701. excel
  702. text in a function
  703. stop rounding up in a colum that contains decimals in excel
  704. Counta and rows..
  705. rank
  706. is there freeware for administration of my home office?
  707. Extract Date
  708. Display row & column number in cell
  709. Array formula and #N/A
  710. Define Name reference
  711. why can't i send my excel spreadsheet?
  712. If than Else Trouble
  713. How to eliminate xero values from pivot table and list top 10 only
  714. need formula help
  715. Military time trouble
  716. update prices in inventory based on downloaded price list??
  717. cell value based on null/not null in another cell
  718. PLEASE HELP - Data Sort
  719. Intercept and Indirect
  720. Percentage function help
  721. Unique Values Only
  722. Many Columns to Many Rows
  723. Selecting Last Sheet
  724. Formatting when referencing?
  725. Can't Copy and Paste
  726. Keeping the format when referencing cells?
  727. How do I setup a drop down box for using addresses
  728. Cell Reference in Function
  729. Macro problem
  730. SPELLNUMBER
  731. I want to create a templete.
  732. Working with first and last names
  733. copy email addresses from excel to yahoo
  734. Formula hijacks cell below.
  735. Data Transfer?????
  736. In Excel, how do I insert a formula to find the 5th root of a no.
  737. Formula Syntax
  738. percentage
  739. Pivot table formula
  740. Getting Difference between two cells
  741. IF Statement (Nested IF's??)
  742. < or > question
  743. color help
  744. Need formula that will sum cells in a column bases on criteria in other cells.
  745. Text Wrapping
  746. trying to print at 100%
  747. Protect a worksheet, but allow ONLY specific users to change info
  748. Summation Formula Needed
  749. Summing Up Data Based on Codes
  750. INTRATE