PDA

View Full Version : 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 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 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449

  1. Vlookup
  2. Vlookup
  3. Finding the highest value from two columns of data
  4. multiply with - if text
  5. Cell by cell transpose
  6. Can I formulaically set a cell to blank (non-Text, no value)?
  7. Offset formula on different worksheet
  8. database over 1 worksheet
  9. Hi all i need some help on excel transpose
  10. how to get last two rows??
  11. what formula is used to find lowest value within cells
  12. Count if two columns match different criteria
  13. Unlock for Viewing
  14. Each rows last cell text value could be in any columns.
  15. return value in adjacent cell different workbook
  16. How can I find/unhide hidden excel sheet tabs on a worksheet?
  17. select list by selecting a cell
  18. delete row
  19. Converting text from rows to columns
  20. Use Excel to make a complex IF function.
  21. create cell formula for...
  22. sum minutes
  23. Automatically adding cells from one worksheet to another
  24. out of rows
  25. excel random sample with criterion
  26. Print Preview is normal, but numbers do not print, just narrative
  27. If formula to test several conditions
  28. Delete rows with duplicate values
  29. Separte columns for neg/pos values
  30. if statement does not work with = sign
  31. Running total that stays with changes
  32. Fill the column with the last number
  33. Can insert W/S but not copy a worksheet
  34. VLOOKUP PullDown Menus Connected
  35. Can I make certain cells required?
  36. Easy question for you all
  37. help to open excel file
  38. How do I program the cells in Excel to add, subtract, etc?
  39. Is there a way to link Auto Filter values to a Cell
  40. Find first numer in a Column
  41. Function that will automatically display the User Name?
  42. Using ISNA with OR
  43. How do I allow for multiple values in VLOOKUP?
  44. formula auto input
  45. Are there any inventory forms that change quantities as needed?
  46. Help with matching formula
  47. Problems comparing data from multiple blank cells
  48. IF statement does not work with "=" sign
  49. Ignoring text and errors with Sumproduct
  50. Lookup Help
  51. Using Morefunc - Indirect.Ext when Offline
  52. Need to keep some info from formulas, but then change the formula
  53. Sum if or sum product?
  54. update a cell by one, trying to count a survey a quick way
  55. Certificate of Deposit calculator
  56. Auto Fill/Sequential Numbering
  57. Restrictions On Merged Cells?
  58. UK Excel User Conference - July 19-21
  59. function to fill all days of month to end of month
  60. sales data how i can list weekly,monthly yearly etc..etc...
  61. Pivot Tables-2 Questions
  62. spread sheets vlookup
  63. formating inputbox result in excel
  64. Count across worksheets with two criteria
  65. use concatenate function to put carrage returns in a text string
  66. Find name in list and get dept # enter dept # on work sheet
  67. Can this be done using Sumproduct?
  68. Mind Gone Blank!!
  69. Why does paging down skip ten rows?
  70. can't delete worksheet--grayed out!
  71. I've never seen this symbol before
  72. Add and Subtract functions
  73. partial/absolute text match
  74. Excel IF Function
  75. min and if
  76. IF function for multiple answers?
  77. Dynamic Ranges--Multiple TableData??
  78. #NUM errors when calculating IRR
  79. How do I enter a blank, not "", into a cell with a conditional for
  80. Delete row by time/date?
  81. storing data
  82. Probabilty - Binomial - a simulation game?
  83. How do I invert text (abc-->cba)
  84. Help with prompting Replace Screen
  85. how do I convert cell 'Street,#' to '# Street' these are addresse
  86. Help needed on Date formulas
  87. Comparing two spreadsheets
  88. Securing A Workbook For Individual Distribution
  89. running macros from IF
  90. "Empty" values in holiday parameter for NETWORKDAYS() function
  91. Calculate the Days
  92. counif greater or less than
  93. Floating CommandButton
  94. Go To last blank cell
  95. Sort a column automatically
  96. Down arrow moves cursor to top of worksheet when sheet protected
  97. average price
  98. Excel formula to calculate % gain when adding cash equity to accou
  99. How do I associate word cells to equations?
  100. Sort info
  101. Degrees Minutes Seconds
  102. Macros in a cell function
  103. Reply for Macropod
  104. data change color automatically
  105. macro
  106. help on match function
  107. I cannot find Invoice toolbar
  108. How do I compare string values in one column to another column?
  109. IF function for blank cell
  110. Can search by cell format like fill color?
  111. Can I use more than three conditions for conditional formating?
  112. how to use a variable for the criteria in a sumif function?
  113. The team who designed Excel insert cut cells was a genius
  114. Excel: Using DSUM, I need to evaluate 2 criteria that are not toge
  115. Inserting new employees
  116. Where to find complex matrix math add-ins for Excel 2003?
  117. MAX Function not returning correct value
  118. Excel Formula
  119. Protection of identical cells on multiple worksheets
  120. Stop a List Box from resizing
  121. need help with lookup function
  122. Help with AVERAGE function
  123. Values from website turned into useable number values
  124. Run a macro automatically at a certain time
  125. Format for degrees
  126. Splitting one column into multiple columns
  127. Gathering Data from various tabs
  128. "Mail Recepient" feature does not work!! Why?
  129. Values In Links Not Being Saved
  130. EASY: Format NOW as mm/dd/yyyy
  131. Activating a Checkbox
  132. Conditional Formatting based on Upper case
  133. BIN2HEX function will convert '511', but not '512'
  134. Listing data without blank rows
  135. Excel 2003 sum figures without formula
  136. Pivot Table Row Formatting
  137. links in Excel
  138. How to get the Excel to calculate the exact date from a given date
  139. Need Help: Summing Multiple Criteria
  140. Sumproduct based on Date range
  141. I WANT DATA TO LINK WITH OTHER WORKBOOKS ACORDING TO CELL CONTENT.
  142. =?iso-2022-jp?B?V2hlcmUgZG9lcyAiYSwbJEIhSRsoQiBjb21lIGZyb20/?=
  143. How do I round to the nearest 5?
  144. averaging & ???
  145. Using SumProduct and Count To Calculate % Ranks
  146. HELP!!!! on formula PLEASE!!!!!!!!!!!!
  147. Pivot table
  148. How do I see the formula calculation used in Excel functions box
  149. Function INDIRECT
  150. Help with a formula
  151. Range Name affecting speed of macro
  152. speech recognition
  153. Need Help With A Formula Please
  154. Specifiying the worksheet name in a cell
  155. Counting Formula
  156. Formula has to take Monday if due date falls on a Sunday
  157. Function to lookup largest value
  158. Trying to do a auto number generater
  159. copying data to different Cells
  160. Negative Values
  161. For Niek Otten and Toppers custom function calculating time
  162. multiple sumif formula
  163. How do I set repeating text for a specific cell.
  164. What function?
  165. Sharing Data by Keyword
  166. Adding Products
  167. Help with IF
  168. Moving up / down in a macro
  169. File size xls
  170. Count dates for previous month
  171. "If this, multiply by this" type of equation
  172. Help with Formula
  173. Could someone tell me the difference in these formulas?
  174. Formula to return an answer using a calculation
  175. Calculating a tiered 401k Match
  176. Formula for running total
  177. Conditional End Date in Data Validation Settings
  178. Random Number response
  179. Mutilpe sheet , multiple formula help please.
  180. I don't want all NOW() cells to recalculate
  181. How do I undo a list I've created in Excel 2003?
  182. Beginner with Excel Here: Need Help with Cell Formatting Function
  183. Find all numbers in database that end in...
  184. Inserting check boxes
  185. How do I create a certain equation in Excel spreadsheet?
  186. How do I sort columns with IF formulas in them?
  187. SUMPRODUCT formula returning #VALUE! error
  188. Using Rank with If
  189. IF formula for 13 plus variables
  190. How do I bold just the totals when using Subtotals?
  191. How do I set up a formula using same field in pivot table?
  192. Pop-up/hyperlink in a cell
  193. Coverting text to numeric
  194. worksheet help
  195. formula to count cells containing #'s in a specific range
  196. Help! [Group] in the caption and I can't use auto filter anymore.
  197. My Excel formala is not returning the correct value
  198. sumif #value
  199. Ask for password after certain date?
  200. Need a Formula
  201. COUNTIF using # ranges, and referencing 2 other columns
  202. Split Profits to different partners based on hurdle rates
  203. Will the COUNTIF function work with auto-filtering?
  204. VLOOKUP not working anymore
  205. How do I make a compound function?
  206. Submit Button
  207. How to display a numeric field showing all 5 characters.
  208. Summing lookup values
  209. Find minimum value greater than a particular value
  210. If Question
  211. Date calculation
  212. count a number range and a letter in a cell
  213. Match - Exact - Lookup?
  214. How can I invert a column's contents
  215. Can I use more complex logical expression for sumif as creteria?
  216. Excel copying with link cells
  217. CONCATENATE TWO DIFFERENT CELLS
  218. Unable To OPen Excel 2003
  219. Track changes
  220. add Trend Line to Pivot Table Chart
  221. excel quotes
  222. Settiing up spellcheck in a protected Excel document
  223. How do I add multiple conditions to a formula?
  224. How do you run a Macro from an IF statement in Excel 2000?
  225. How do I use the "if" and "round" function in the same formula ?
  226. How can I play a .WAV file in Excel if a condition is met?
  227. countif = < > AND value in adjacent columns match criteria
  228. Graphing Normal Distribution Functions
  229. Averaging Text vs. Numbers
  230. Hyperlink- relative reference
  231. Worksheet - Quote log
  232. IF protection then skip sub.
  233. Two pivot tables on the same worksheet? I need help...
  234. Dynamically set a range?
  235. countif
  236. Calculating Current Age from DOB
  237. How do I solve the error this #VALUE! error
  238. Forumula help using Countif
  239. Extract data from one worksheet
  240. Need help on counting text within certain criteria
  241. filtering unique data
  242. automatically insert formula when new rows are inserted
  243. How to give function by cell color to sum two value in Excel
  244. Can I auto insert a worksheet when I insert a value in a cell.
  245. How do I convert Numeral to text
  246. Sorting of References for Formulas
  247. Moving data between sheets using buttons
  248. Return blank cell if 'find' statement not true
  249. Improved Excel functions curve fitting in sheet
  250. Need help calculating formulars