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. CALCULATION OR FUNCTION ERROR
  2. formula trouble
  3. golf handicap formula
  4. Data Consolidation
  5. SUBTOTAL Second Count / sub-count of Filtered Visible Cells
  6. Planning system
  7. URGENT: Adding Text to existing text
  8. LINEST
  9. Count Number of Dates in Date Range
  10. 2 values to one column
  11. calculate Score by function
  12. RISKTNORMAL
  13. Excel training exercises
  14. Drop down box
  15. Formula or Macro?
  16. Return address of last cell
  17. Excel : Calculating Elapsed Time
  18. Day/Date problem
  19. *.xls:1
  20. Set a column to not print
  21. zero vs. null value
  22. Days left until...
  23. Weighted Average for Different Aggragates of Duplicate Entries?
  24. Calculating Calendar Dates
  25. Calculating Time Zone Differences
  26. range name vs multiple cells
  27. vlookup function
  28. calculating dates based on workdays only
  29. Consolidate data from different files
  30. Employee Reviews Pulled by Date Range
  31. Excel Reference or VLookup?
  32. Help with Graphs!
  33. String seach within an Array
  34. Sum Values after finding last cell
  35. Referencing a cell open a workbook
  36. ActiveWindow.ScrollColumn (Question)
  37. Convert positive numbers to negative
  38. FV function (pv argument)
  39. links and weighted least squares
  40. Changing Text color when a date has past
  41. formula to count subtotaled rows
  42. Shared Workbooks and Taskbar
  43. "and" "or" in formulas
  44. prime function
  45. Formula
  46. formula
  47. Conditional Format - new
  48. 3D array/sumif formula
  49. linking worksheets (ex. =sheet1!A2)
  50. interrelated constraints
  51. Re: Getting the reference path that a cell is pointing to
  52. Macros
  53. Data Validation
  54. Multiple selections from a drop down box
  55. Re: Excel 2000 Using COUNTIF statment with OR statement
  56. Linked workbooks
  57. excel sheets
  58. Formula meaning
  59. Help please
  60. Lists (Using INDEX vs. MATCH function)
  61. Copying Conditional Formatting
  62. Excel - filter results in column, need to find adjacent column data
  63. Consolidate data
  64. Margins Do Not Fit Page Size
  65. Degrees Minutes and Seconds
  66. Range names selected from within a cell
  67. vlookup using 2 reference columns
  68. Filtering based on two different range criteria
  69. Countif
  70. DGet Function
  71. Defined names and SUMPRODUCT
  72. Would use Array formulas but....
  73. replacing text/ data throughout workbook
  74. Watermarks
  75. Text
  76. Automatically Bold Portion of Text within Cell
  77. Workday
  78. VLOOKUP
  79. Age using date formula
  80. Macro mistake.
  81. Excel spread sheet cell
  82. skip cells on data entry
  83. Reference a ToggleButton in Cell Formula
  84. help with Conditional Formating
  85. change multiple formulas at once
  86. Combo Boxes, List Boxes
  87. COUNTIF
  88. GETPIVOTDATA with Date
  89. GETPIVOTDATA with Date Criterion
  90. blinking cell
  91. Normal Distribution Curve
  92. Fill / Series / Alpha
  93. Add/subract the same value to every line in a column
  94. Summing values with Multiple criteria
  95. Summing values with multiple criteria
  96. Conditional formatting and "autoselecting" cells
  97. excel
  98. templates with data tracking
  99. LOOKUP functions from cells containing formula . . .
  100. Counting letters for male/female
  101. =ROUNDUP formula question
  102. how to switch a #N/A value into 0
  103. how to switch a #N/A value into 0
  104. Need Formula Help!
  105. EXCEL
  106. Linking to Another Workbook
  107. Pasting large amount of text into a single cell
  108. HELP CREATING A FORMULA
  109. Degrees minutes seconds to degrees
  110. Backfilling monthly volume forecast based on annual forecast
  111. How to take out comma (,) in name format
  112. How to remove Comma In name fornat
  113. counting cells in a range w/two attributes
  114. OFFSET
  115. creating a "time stamp"
  116. "Between" Formula
  117. Calculation a running total w/out creating a circular reference er
  118. drop down menu calculation
  119. pushing results to another cell
  120. dget() on l_o_n_g text
  121. Worksheet sharing
  122. formula needed to convert a numeric value to text.
  123. Dget problem. More than one row
  124. vlookup
  125. Calculating a cell address
  126. #Value
  127. Match builtin Excel function
  128. IF only.....IF only....
  129. using the forecast function
  130. #VALUE
  131. Username
  132. dates
  133. Sumif ???
  134. lookups
  135. "Last saved" information
  136. Changing negative numbers to positives..
  137. Vlookup post codes/zipcodes query
  138. Trying to total the number of times a word occurs
  139. count instances based on two criteria
  140. Text
  141. opening a read only file
  142. dates
  143. Conditional Formatting Formula
  144. Subtotal Quirkiness
  145. Convert Number to Time
  146. How do I retuin a list from hyerlinked total
  147. Date options
  148. monthly compound interest - is there a better way?
  149. Changes from Excel 2000 to Excel 2002
  150. TRIM functions
  151. Deleting & Inserting Rows
  152. Inputting info on one worksheet and having it post on another worksheet by location
  153. TEXT
  154. Text in formula answer2
  155. IF
  156. Turning off auto date formatting
  157. Finding roots of non-linear equations in Excel
  158. how to conditional sum in a matrix
  159. SUMIF with multiple criteria
  160. using Vlookup to find multiple results
  161. Named of Named Ranges for validation
  162. Days in Month
  163. Lookup with variable name
  164. Calculate a rate based on whether or not a date is between 2 other
  165. Macro help
  166. Custom Function Problem
  167. pivot table drop list
  168. Change this formula for military time?
  169. Q: Dynamic Sum function?
  170. Macro Help
  171. SUBTOTAL Second Count / sub-count of Filtered Visible Cells
  172. Extracting data from a table
  173. IF, AND, BUt
  174. Excel
  175. Search either of two items
  176. MROUND Function
  177. auto underline
  178. Search Function
  179. Hard to describe this one
  180. IRR (INTERNAL RATE OF RETURN)
  181. looking values in tables
  182. Help with long formula - how do it shorten?
  183. Copying Data from One Sheet to another
  184. Frank, I need your help, PLEASE
  185. Print area ?
  186. Round up to the next 200
  187. Lookup and then some
  188. Lookup
  189. If nested function
  190. Excel comments
  191. comparing todays volume to yesterdays
  192. Address Function
  193. Problem with the lookup.
  194. Excel 2003: Need help converting from text to date/time format please
  195. Drag Handle
  196. changing time format when concatenating
  197. Linking to Dynamic Named Ranges (Excel 2003)
  198. Use a cell value to refer to another worksheet
  199. Nested IF to deep
  200. Cell number of a maximum value
  201. Convert dollar amount to text
  202. IF
  203. Fixed cell reference
  204. Column widths
  205. transposing problem, may need some kind of function
  206. can't print worksheet as report
  207. Excel AVERAGE formula - Selective averaging in an array
  208. How to perform an automated AutoFilter sort
  209. ListBox
  210. Moving only certain cells to another worksheet.
  211. Publishing worksheets as a webpage
  212. Formula to fill a cell
  213. Hardware inventory
  214. Toggle
  215. Analysis Toolpack - NETWORKDAYS - Add in
  216. Trying to transpose and format large matrix
  217. VLOOKUP #NA unless retyped
  218. Protecting Sheets within a workbook
  219. worksheet protection
  220. "Last saved" information
  221. Find the First Blank Cell In a range
  222. Advanced countif() help needed
  223. Filter macro using criteria in a list (not autofilter drop down list)
  224. Excel Sort() Algorithm
  225. Finding the first blank cell in a range
  226. For =IF function to display a picture as its value.
  227. Sort Question
  228. HELP....
  229. countif if bolded ?
  230. Increment an Invoice number
  231. Custom Function & Personal.XLS
  232. SUMIF ?
  233. protecting single cell
  234. Copying formulas on worksheet
  235. Linking spreadsheet to Word doc
  236. Range Names
  237. Re: worksheets and workbook
  238. Highlighted Cells
  239. Financial Calculation needed
  240. Sorting by the last numbers in a long number
  241. How to calculate days:Hours:Minutes:
  242. Is there a formula for a decreasing montly balance of a mortgage?
  243. create own data
  244. Search with wildcards symbols in IF fnction
  245. Array Function?
  246. formula problem inside a macro
  247. Sharing Violation & Unexpected file Lock
  248. State Machine in Excel
  249. Relative & Absolute References
  250. Forms
Google