PDA

View Full Version : 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 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352
  1. Easy formula Question
  2. Spreadsheet Historical Prices for European Stocks
  3. Can't find the right lookup formula for this
  4. Formatting in IF Functions
  5. COUNTIF with compound comparison
  6. Look up of data in a different Sheet
  7. HELP....Is there a way to automate copy/paste special/transpose -
  8. TEMPLATE FOR VALUE PREMIUM
  9. IF function?
  10. Constant Value in formula.
  11. How to keep rows together when sorting columns?
  12. Copying and PAsting using MACROS
  13. Need a ISWorkday Function -- Any Ideas
  14. Email/Save/Macro
  15. copy every 30th cell in the column into consecutive cells in anoth
  16. Need help using search functions
  17. How do I convert cells containing formulas to text (value returned
  18. How do you print all data in a cell?
  19. pivot tables
  20. employee scheduling
  21. Deleting many named ranges
  22. Insert characters in a text string
  23. Count cells in one range based on parameters in another range
  24. How do I assign sequential numbers in an Excel 2003 PO template?
  25. Count and Sum Total occurrances of two specific numbers
  26. Vlookup - double criteria
  27. Adding Work Days only in a function?
  28. Vlookup - double criteria
  29. Worksheet database
  30. VLOOKUP - DOUBLE CRITERIA
  31. How to IF dates?
  32. ### when the number is NOT negative?
  33. If formula
  34. Comparing a value to a list of values does not work in Excel 2003.
  35. how do i copy a formula's result to another cell, without copying.
  36. Evaluating similarity of text strings
  37. List of repeating names
  38. Using COUNTIF to check values in multiple columns
  39. Fill formula question
  40. rounding to closest 5 cents
  41. Networkdays problem
  42. calculating moving average
  43. Export from excel
  44. How do I lookup values from rows and columns Simultaneously
  45. Cell problem
  46. Hyper Links
  47. MACRO
  48. how do I write a formula to round up a number?
  49. how do i change footer settings on multiple sheets at the same ti.
  50. Opening two excel worksheets with dual monitors.
  51. Work books
  52. How do I calculate present value of a single sum?
  53. How can I link a cell in one worksheet to a cell in another works.
  54. How can I create a formula to locate data between two dates?
  55. Returning Multiple Values Based on One Value
  56. Stop numbers converting to dates.
  57. Animate excel?
  58. Precedents do not work
  59. Can you make cells in Excel flash or twinkle?
  60. Creating Formulas
  61. if function errors
  62. Save as not working for laptop to desktop
  63. If statement help
  64. Tool > Compare and Merge Workbooks... This is not a highlighted .
  65. Cursor wil not move left in worksheet
  66. Excel should allow me to freeze pane in a split window
  67. Combobox/tab order
  68. HELP!! Need help with if/and/then/copy statement!!!
  69. sumif range of varying size
  70. Sum of a column
  71. Why not nest more than 7 functions in Excel formula???
  72. referring to other worksheet
  73. Plotting Dates
  74. Trying to enter a range of numbers using >1 and < 5 in a formula
  75. Help with importing from Outlook
  76. Drop down list with multiple choices
  77. Insert rows
  78. Worksheet Protection
  79. If Statement - in time not decimal minutes
  80. If (either of these) return this
  81. Renaming Worksheets
  82. How do I take excel data and convert to label/envelope form?
  83. Updating rows - Excel Formula or Something Else?
  84. dates change to numbers
  85. Match Last Occurrence of two numbers and Return Date
  86. vlookup with two criteria
  87. If I create a random list in Excel, does it repeat numbers?
  88. recognize formatting
  89. lognormdist function
  90. How can I trim "4|+|23.68^" into "23.68" in excel 2000?
  91. Lookup with 3 criterias
  92. autofilter problem
  93. i want my excel colums to be rows
  94. Using Indirect Function
  95. Formula Assistance
  96. time differences in a column
  97. Insert Row
  98. Some exported records do not show on spreadsheet
  99. How do I create a workbook that links info in cell to a calendar?
  100. How do I subtract column 1 from 2 and show results in 3?HELP!
  101. Replace with subtotals
  102. How do I return dynamic lists?
  103. Ptable - 2 in a workbook for the same data?
  104. Re: How to format cells in Excel for time in format mm:ss.00
  105. Add ins for Excel 2000
  106. Decimals separation "." and ","
  107. Bahttext only display in thai?
  108. how to brack prtection password in microsoft excell in tools men.
  109. Lookup the month in a date string 01/03/05
  110. How do you do a culmanative frequency in excel
  111. How can i convert Text Case in EXCEL?
  112. Cell addressing using the content of another cell.
  113. Cell addressing using the content of another cell.
  114. Can Excel represent formula in textural format with values substi.
  115. How can I create drop-down lists with references in other workboo.
  116. Multiple minimums for the same column
  117. Conditional Formatting
  118. Question about financial calculation PMT
  119. Split cell values based on content
  120. need help finding a Date range within long list
  121. follow-up from yesterday's "creating formulas"
  122. how do i sum 2 values that fall between date ranges?
  123. I want to create a macro to where after we enter data in a spread.
  124. Explode Cell Data
  125. how do I assign a symbol to the result of a part of a nested IF s.
  126. Sending a group email
  127. Formulas
  128. IF, AND, OR Conditional formula?
  129. IF, AND, OR conditions?
  130. how do I change case in an entire column of text in Excel
  131. Converting Columns to Rows
  132. fax multiple worksheets
  133. Using date function in an if statement
  134. data in empty cells
  135. Value to text words conversion
  136. How about adding a quarterly function to Excel like its EOMonth?
  137. Working w/ non-standard Time Format
  138. Can I select a worksheet based upon a cell criteria?(for printing)
  139. Totaling rows of text
  140. MY WORKBOOK WON'T LET INSERT ANOTHER WORKSHEET.
  141. SUMIF/SUMPRODUCT??
  142. Auto Calc not working
  143. How do I set up a equipment replacement reserve schedule
  144. RUN CONSECUTIVE EXCEL DATES ON DIFFERENT PAGES IN WORD DOCUMENT
  145. How can I run a macro in a protected worksheet?
  146. Excel running date formula minus weekend days
  147. Pivot table report
  148. Calculate Due Date
  149. Separating dollars and cents
  150. Need Formula for Date Conversion
  151. How to copy conditional formatting
  152. Pivot tables-multiple payments
  153. Excel static current date/time problem
  154. I want to select excel cells of difference colors and increase th.
  155. Is there a way to change text color using the Logical IF statemen.
  156. Updating master workbook from source that may/may not exist
  157. EXCEL 2003 PROBLEM
  158. Computing totals for tax and non-tax items
  159. How to convert a series of numbers
  160. Transfer Items to a list with no duplicates
  161. Rounding Question
  162. Formula linked to cell with Macro
  163. how do I make a heading row "float" to follow the data as I scrol.
  164. EXCEL 2003: Apply Conditional Formatting to COLUMNS
  165. copy visble cells at the subtotal level
  166. TURN LOWER CASE TO UPPER CASE IN EXCEL?
  167. Counting within a cell
  168. How do I link 2 worksheets in different files?
  169. HOW CAN I READ SPREADSHEETS CREATED BY OFFICE 2000 ON OFFICE 2003.
  170. sorting with data on alternating [every other] row
  171. sumif with two conditions
  172. Need a simple formula please
  173. calculate permutations of nonnumeric data
  174. move page breaks
  175. Color detection
  176. import select data from another workbook
  177. How do I auto-protect a worksheet?
  178. How do I add the count function to the toolbar?
  179. Extracting worksheet names....
  180. detect cell color and count it
  181. how to write macro after autofilter is applied
  182. Home account
  183. Auto Update Links
  184. Calculate time and cost
  185. VLOOKUP TABLE_ARRAY
  186. Spread Sheet Tabs
  187. Absolute average
  188. In excel pointers should be availible
  189. looking for help on....
  190. Creating Drop down menus in an excel cell
  191. HOW DO I CONVERT CELLS/ROWS FROM ON FORM OF MEASURMENT TO ANOTHER
  192. difficulty changing cell format
  193. What are the tricks using "=(SHEET1!cell_reference)".
  194. in excel how do I show a number as an alpha eg 65 as sixty five?
  195. Returning Multiple Values Based on One Value
  196. Working with If statements and time
  197. I need a VLOOK-UP formula that uses two look-up vaiables in seper.
  198. dates and concatenating
  199. Set Tab key
  200. quotation form
  201. delete all text that match
  202. formula for calculating # of days between 2 cells
  203. Concatenate & Force argument to End of String-(spsjp)
  204. How to calculate a sum as one outcome of an IF statement
  205. I need to know formula for matching retirement percents
  206. functions
  207. formatting date
  208. round up cells to $xx.99
  209. Microsoft excel 2000
  210. Can Excel "slide up" rows with content thru empty rows to condense
  211. Only want color to show when cell is active
  212. Cell content elimination; duplicate
  213. Old, LOTUS 1-2-3 based function
  214. indicate whether a cell contains a formula
  215. formula SUMIF or whichever one will work for my issue
  216. Datbase check
  217. EI_CALC Function
  218. Remove leading Numbers from text
  219. SUMIF problem
  220. Find project start and end dates in a DB with many different proje
  221. inventory counting
  222. What formula do I use in Excel to determine whether one cell fall.
  223. How do I sort data from various worksheets in the same workbook i.
  224. Can VLOOKUP deliver the second occurence when target column entri.
  225. Excel question? Regarding cell formula
  226. Summing Every 40th cell?
  227. Help combine 2 formulas into 1
  228. index / match function
  229. simple formula with blank cells
  230. How do I pull information from one worksheet to another using cer.
  231. countif/sumproduct on multiple criteria
  232. How do I sort by complete rows in excell
  233. how do you get excel o calculate antilogs
  234. Why do I get a #Name error when I use the DateDif function?
  235. Why do I get a #Name error when I use the DateDif function?
  236. can i sum up only visible cells?
  237. format cells
  238. How to share data between worksheets?
  239. Help with formula please
  240. initiating a macro
  241. How to convert entire excel document from lower to upper case
  242. save external link values
  243. Data $9,620,320 principal, 360 # payments, 9 % rate, fv 0. Why do.
  244. how do you calcualte a payment for a loan.
  245. How can I get a count of cells in a range that are shaded a certa.
  246. Set a value, use it later (possible VBA?)
  247. saving options along with spreadsheet
  248. Data validation not showing drop down
  249. Set values in functions??
  250. how do i change a spreadsheet into labels?
Google