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. MULTIPLE IF FUNCTION
  2. Help needed changing date formats from m/d/y to d/m/y
  3. NETWORKDAYS - Non Add-in Alternative - Cannot get it working
  4. Removing hyperlinks from a whole column
  5. Excel Marcos and Programs
  6. problem with Cond. Format for a cell containing #N/A
  7. Cell Name Box
  8. Lookup in an Array
  9. Re: limit data entry to predetermined list
  10. #NUM! error on CUMIPMT function
  11. Re: COUNTIF single criteria across multiple sheets??
  12. opening embedded document
  13. Re: Automatically populate cells based on input of another cell
  14. Insert images in excel sheet using VB
  15. Re: Calculating new dates
  16. Simple Countif problem
  17. TABLE WORKSHEET FUNCTION
  18. fill in blanks
  19. Re: how to select cells which includes includes date for e.g. 1/1/2003
  20. Re: Calculating Time By 15 minute periods
  21. Will ANYONE HELP!!!! this is my 4th posting
  22. John W's software
  23. Re: Return value based on contents of another cell
  24. Separating data in a cell
  25. # sign showing up in cells
  26. Re: Sum select values from a list
  27. Date Validation
  28. DSUM
  29. looking for Excel Function Reference book from 1992?
  30. Re: automatic Column Width
  31. Date Values
  32. Count the times a number appears in a column
  33. Re: Combining IF Statements
  34. Timecode in excel
  35. Keeping Worksheet colors when saving as interactive htm pivot table
  36. Reading ACCESS data from an EXCEL Spreadsheet
  37. Forgotten passwords
  38. Converting Sanned documents into workable Excel file
  39. Re: conditional constraints on subtotal fn
  40. Handling Leap Years in Calculation
  41. Re: Replace getpivotdata's "#REF!" with "0"?
  42. Ready and Calculate at the some time in status bar
  43. Auto Save
  44. Excel combo box
  45. COUNTIF
  46. Excel - formulas
  47. Re: Days365?
  48. Formula for Date in a Cell
  49. file size growth after hiding rows or columns
  50. column search and post
  51. Dates in a Range
  52. Menu Options "grayed out" but still functional through macros
  53. Array formulas will not copy.
  54. Using a Template to View Multiple WorkSheets
  55. Workday function in Excel
  56. Grouping
  57. Pivottable trouble big time!! Please help
  58. offset/match
  59. Pasting Color Graph from Excel into PowerPoint goes B&W
  60. Getting Excel to retain data from past spreadsheets...
  61. ASC( ) in EXCEL2002
  62. column width, row height units
  63. Vlookup function
  64. Regarding Excel workbook unlock
  65. drop down menus
  66. macros across multiple worksheets in workbook
  67. Excel Macro Problem, Add-in need to work in every workbook & Error:9 Subscript out of range
  68. Book 1
  69. Filename
  70. Save only one sheet of workbook with vba statement
  71. Merging worksheets
  72. What's wrong the formlua
  73. rounding dollar amounts
  74. Counting Unique Values Using "Starts with" Criteria
  75. If ..
  76. Time and Mileage incompatible
  77. Sorting street address
  78. using a macro to move values in cells if they are a negaive value
  79. vlookup function returning #n/a
  80. Leaving Cells of Currency Format Blank
  81. excel worksheet
  82. security
  83. Merging Worksheets
  84. if statement - text / blank cell
  85. counting specific cells
  86. All Caps
  87. printing form or a database like
  88. labels
  89. Numbers that show as there but won't sum
  90. Search and replace string in formula with string from cell
  91. Formula copied to new cells returns value, not formula result?
  92. formula's in cells
  93. save setting for print entire workbook
  94. Random Number Generator - Help!
  95. Referencing cells
  96. Linking workbooks with sorted data
  97. Formulas
  98. YES/NO statement
  99. Formula to calculate date difference
  100. Linking Spreadsheets
  101. Concatenate Carriage Return
  102. Excel 2003 worksheet functions
  103. formatting tab in worksheet
  104. Formatting tabs
  105. Unhiding work sheets
  106. formulas
  107. Re: Unhiding work sheets
  108. copying one sheet to another
  109. number formatting time codes
  110. formatting text in cell
  111. Resetting horizontal scrollbar
  112. Linking a number automatically to several sheets
  113. Allowing access to 'grouped rows' whilst worksheet protected
  114. macros in excell 2000
  115. Calculating Ages
  116. Check Boxes And Macro HELP
  117. GOTO
  118. Engineering Notation
  119. How do I format this cell
  120. NETWORKDAYS Function
  121. DEFAULT
  122. formula for averaging months
  123. array or IF formula problem (?)
  124. format ssn to show w/o dashes
  125. Can I "sign" my own macros? or some other fix for the message about security and macros?
  126. =sum with 2 criteria
  127. paste link and transpose simultaneously
  128. Count function...i think
  129. Change items from down - to across
  130. count function??
  131. count function??
  132. Re: count function??
  133. I would like in column A to display names of all my worksheets.
  134. Table "What If" Set Up If I Change One Or Two Variables
  135. Re: any way to change array size?
  136. Square Root Forumula
  137. Averaging-completed e-mail question
  138. multiple arrays in single statement
  139. Formula references when copying a workbook
  140. zero
  141. AVERAGE function does not work
  142. Excel - Vlookup
  143. Help Please with Growth Formula
  144. Random function
  145. formulas
  146. Re: multiple arrays in single statement
  147. Combo Boxes and Dates
  148. Leading zeroes
  149. Word/Excel Linked Templates not saving on exit
  150. Table of Contents and Idexing
  151. Need formula to post data from one workbook to another workbook
  152. macro to save a workbook as a .csv file type
  153. Shading every other line
  154. Re: Row Validation???
  155. Sumif question
  156. Re: Blank cells
  157. Pivot tables
  158. Max # rows to process in excel
  159. Need a formula
  160. XIRR
  161. Re: Change case in database fields from CAPS to Proper
  162. Link to different tab on worksheet
  163. #N/A
  164. navigate on a sheet down "x" rows
  165. Embed the value in a cell within the offset command
  166. Calculating currency values
  167. Decimal?
  168. Re: Returing a value depending on hi-lo range
  169. auto printing
  170. God
  171. How Long
  172. Multiple Column Lists - Different!
  173. Re: Multiple Column Lists - Different!
  174. GetOpenFileName
  175. Excel-Date Calculation Question#1 of 3
  176. Re: What function do I use?
  177. VisualBasic/Excel "GetOpenFileName"
  178. IF help
  179. VLOOKUP and Combo Boxes
  180. linking data from dbase to spec sheets
  181. how to find 80% value using formulas?
  182. "OR" function
  183. Rounding Up to Nearest 1/4 Decimal
  184. How to Change the Color of multiple cells when multiple cells returns text of "x"
  185. Formatting and concatenate ?
  186. Finding a Circular Reference
  187. Macro pop up warning
  188. DATE
  189. DATE
  190. DATE
  191. Concatenate
  192. Excel
  193. Excel Treats All Dates from the Previous Century as TEXT & Can't Change Format
  194. compare Excel files ?
  195. Convert UNIX dates
  196. CountIF
  197. Is it possible to print without the colored cells printing any color?
  198. Countif multiple criteria in same cell
  199. MAX function
  200. Re: table lookup function
  201. xirr function
  202. Need to reduce amount when another amount is entered
  203. count conditional format colour
  204. Macro to read to end of column list
  205. Use date document created in formula?
  206. SORTING
  207. Automatic calculation
  208. Percentage difference between two numbers
  209. Macro for Selecting Several Worksheets....
  210. All pastes from other apps altered after macro - not what I wanted
  211. FINDING A COMBINATION FROM A LIST TO EQUAL ...
  212. Data validation query
  213. Password protect & read only
  214. Pivot Tables and Formatting
  215. VLookup is odd
  216. HELP! Return data if cell in row contains data
  217. VLOOKUP
  218. Irr function
  219. Re: Logical test to return one of three values
  220. nested if and ranges
  221. Is it possible to automatically sort cells easily? (I'm going mad!)
  222. designing & installing icon add-in for macro
  223. Excel / Email Macro
  224. Compare and Merge
  225. Forecasting sales volume totals
  226. A dilly of a question!
  227. SUMIF Formula
  228. Difference in time (in minutes)
  229. not eqaul
  230. getting a cell address from a VLOOKUP
  231. Re: Difference in time (in minutes)
  232. Re: Nested Loops - If function
  233. Re: FILL A RANGE OF NUMBERS
  234. Dropdown Box to Select Data from Another Sheet
  235. Nesting a nested function with {..}
  236. Re: Nesting a nested function with {..}
  237. Re: Nesting IF statements with {..}
  238. Re: Summing compounded growth rate periods
  239. Summing problem
  240. getting vlookup to return a formula instead of a value
  241. Sorting
  242. IRR
  243. Re: Create a macro to copy worksheet 52 times & rename
  244. Excel file Size Issue
  245. Re: How to Transpose a table to a single column
  246. Tool Bars
  247. Re: Change sign of entire column of numbers
  248. RE: Ignore blank cells in formulas & in average
  249. Stock quote does not work in Excel
  250. Extract data from a list within a specific date range
Google