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. How to create the unique list from data
  2. look at another cell to determine which sheets cell to display
  3. Weird Page Break
  4. Formula Conditional Formatting
  5. Data between Parentheses
  6. [SOLVED] Auto Cell color
  7. replacing amounts of data in a worksheet.
  8. Worksheet reference over network (security issue)
  9. Ranking Against Selected Cells, not ranges?
  10. [SOLVED] How can I make a cell blank if another cell is blank?
  11. Finding the mode value from a table
  12. stability of MATCH function?
  13. What formula, horizontal and vertical
  14. Calculation of Productivity
  15. COUNT on steriods?
  16. Automatic highlighting of function arguments
  17. generating numbers to equal #
  18. Calculating future dates with networkday
  19. Return highest 4 values (MAX?)
  20. summary worksheet
  21. Generating and referencing filenames as formulas
  22. MID Formula
  23. Look up a list of email addresses?
  24. Conditional formatting with a drop-down
  25. Batch conversion to excel format
  26. List numbers by order of frequency?
  27. cell coloring based on duplicates
  28. Figuring out Skins for Golf
  29. Summing YTD info??
  30. Minimum value to produce x mean
  31. [SOLVED] Rounding currency to the nearest .x9 cents
  32. [SOLVED] TRIM function and leading spaces
  33. Reference a cell from an another sheet which is incremental
  34. Vlookup
  35. [SOLVED] Displaying the current opened file's directory path?
  36. If E=L then I=G+H, If E=S Then I=G-H. How???
  37. #DIV/0! Error when Averaging empty cells
  38. Finding the Max Number
  39. #DIV/0! Error when Averaging empty cells
  40. Determine Quarter & Year
  41. Count (But not formulas)
  42. Drop down boxes and automatically populated fields?
  43. Conditional Formating with reference to another cell
  44. Lookup doesn' choose the right words???
  45. Carry Over Total Problem
  46. How to take Counts for the series of numbers in excel
  47. find the high temp of the day from may temperatures per day per month
  48. Grouping and showing items only once..?
  49. Get a cell value from an array of cells that isn't in a separate array of cells
  50. Perform IF calculation only if text is displayed in other cells
  51. Not sure which functions to use
  52. PMT() Formula
  53. Offset from Max Value in non-array Cell selection
  54. SUMPRODUCT Difficulty
  55. Hyperlink Result to Source Data
  56. Counting "YES" and "NO" throughout workbook
  57. Return the Earlist Date
  58. Formula to reference another sheet
  59. Formula To Remove Blank Cells
  60. Calculating A Formula Only If There Is A Value
  61. Prorated Salary Formula
  62. [SOLVED] 25 Deals in 1st 30 Days
  63. Using IF and CONCATENATE together
  64. Searching multiple worksheets
  65. Converting a Number score to an equivalent Letter score
  66. IF function problem
  67. returning multiple match values w/ Vlookup??
  68. Display information if...
  69. Summarised Worksheet
  70. [SOLVED] Date function (conditional formatting)
  71. Linking 2 Control Toolbox Functions
  72. excel can do this 120k list split it to 5k each
  73. Automating multiple cells using a Stat/math function
  74. Need help with MID
  75. Protecting formulas
  76. DCOUNT Problem matching critieria
  77. Boolean multiplication to get around IF limit
  78. Error in SUMIF formula
  79. SUMIF with multiple criteria, text and numerical
  80. Data consolidation
  81. copy duplicate data from two workbooks into new workbook
  82. trouble formatting dates
  83. replacing the column and row borders
  84. Rounding to specific values
  85. Need a function for consolidation
  86. Nested IF limit
  87. Making worksheets stay hidden
  88. Can't unhide columns A thru BB
  89. Lookup & output of multiple values related to ID in column
  90. SUMPRODUCT or other way??
  91. Mysterious linked cells and want to unlink
  92. auto sum on citeria
  93. Xl vlookup
  94. If value is between two values
  95. [SOLVED] How tu make a formula look for something that IS NOT there?
  96. page name from a list in a function
  97. Counting cell entries depending on specific condition
  98. Sorting Data Problem
  99. automating a function
  100. Formula to filter product movement by date range
  101. How to automatically adjust a field
  102. How to separate numbers and letters in string
  103. Changing Repetitive Entry’s
  104. use 0f -- (double minus)
  105. formula to sum multiple returns
  106. Link two xls documents
  107. Compare Columns within a Range
  108. counting cells - strikethrough text
  109. Match a name to a team - VLOOKUP?
  110. VLOOKUP not working as desired
  111. Auto fill cells depending on Drop down List selection
  112. [SOLVED] If - help
  113. [SOLVED] showing the expiry date
  114. Can I have Excel count up my stock requirements?
  115. Picking part of a cell
  116. Howto concatenate Array values
  117. Sumproduct error message '#value!'
  118. How to update an excel list? Not quite sure...
  119. Find function- Lookup, Vlookup
  120. selecting a few columns from a web query
  121. How to write an if function based on cell value
  122. how to write an average function when skipping rows?
  123. date formula
  124. Adding time logs from a GPS device
  125. Change font size based on a Cell Value
  126. problem with grouping in pivot tables
  127. Goal Seek using Time
  128. [SOLVED] Multiple conditions
  129. reciprocal equation II
  130. Extend Max formula
  131. Auto-Filter Corrupt
  132. reciprocal equation
  133. Auto Filter with COUNTIF
  134. Ignore values over an average.
  135. Reporting from chart using COUNTIF... I think?
  136. Converting Dates
  137. [SOLVED] Calculating 10th date from list
  138. Grade worksheet function
  139. Using If,then function with 3 value criteria
  140. Count Multiple Entries, Return Multiple Rows, Based On 3 Criteria
  141. SUMIF Formula
  142. Compare flaps and delete info
  143. Lookup with a Pattern
  144. Formula Averages
  145. Networkdays
  146. Sum using 2 criteria
  147. COUNTIF, SUMIF or SUMPRODUCT?
  148. Roundup by 5's
  149. Function to return value of adjacent cell
  150. Counting unique entries
  151. IF THEN Formula with Range Check
  152. Find the Top 5 Values in a range of Cells
  153. Date to Text Conversion
  154. Sum of rows containing number and letters
  155. Copying only certain data to a new worksheet
  156. IF statement with AND
  157. Counting cells that have turned green
  158. Matching two columns of data that are smiliar but not exactly the same
  159. Hyperlink Result to Source Data
  160. Calculating time elapsed in days and count days within same range
  161. Sumproduct Formula Not Working Consistently - Date Issue
  162. Choose function
  163. Countblank in B if criteria in A?
  164. Need formula
  165. Formula fill error
  166. Finding duplicates
  167. Multi Nested function formula Error
  168. nested IF
  169. formula to color cells
  170. generate a flowchart??
  171. Date Arithmetic
  172. If/lookup formula
  173. manipulation (Replacing fe characters) in string
  174. vlookup and going to the next largest value
  175. Not sure what im doing
  176. How can I accurately predict a sum of total calls made
  177. Highlighting low quantities from Total
  178. Sum excluding n/a's
  179. Transfer Data from One Sheet To Another
  180. reverse vlookup?
  181. Formula required
  182. need urgent help on a excel function please!
  183. Formula to calculate Period & Week into Date?
  184. Conditional Formatting
  185. Reference a sheet as a key to insert data.
  186. Multiple returns for one id
  187. CountIf with valule critera?
  188. Historical Aging Report
  189. Sum formula
  190. Counting dates with Conditional Formatting
  191. [SOLVED] Fill in blanks with the value of the cell above
  192. IF and or function
  193. Using Vlookup & Indirect to Ref List and Vlookup Files
  194. Sort basic numbers
  195. Formula that is like Custom Auto Filter
  196. [SOLVED] Function to count number of text instances
  197. I need to gernerate a date based on info in other cells.
  198. Transfering Data between workbooks
  199. Retaining absolute cell references
  200. excel formula conundrum
  201. vlookup using names
  202. IF OR formula
  203. random order numbers
  204. Copy Rows based on Duplicates
  205. Using cell values to define a search field for duplicates
  206. Help with a formula
  207. How to find the three highest numbers
  208. Can I add a printable background to a worksheet
  209. referencing values from seed file
  210. search for multiple text strings within an IF statment
  211. If / CountIF / Match-Need to count cells until value met
  212. Using a range of values in a lookup function
  213. Pivot table via external data sourse (cvs)
  214. Change cells to a negative Number
  215. Multiple Lookup Function
  216. Match two lists of data, if set A is >25% of set B output difference
  217. COUNTIF with Cell Reference
  218. IF Function problem
  219. [SOLVED] Formulas Needed To Display Value If Two Conditions Apply
  220. SUM Function if Value in another column is > 0
  221. Vlookup Exceptions help
  222. Basic SUMPRODUCT formula question
  223. Percentage Calculation
  224. Conditional Min function
  225. Hyperlink Creation
  226. Averaging the Difference of Two Columns
  227. Linking cells from one workbook to another..
  228. vlookup on a "right" formula
  229. Help simplifing and existing spreadsheet
  230. worksheets won't communicate
  231. Translate formula into a sentence
  232. help with this foruma
  233. Is an "if" statement what i need? One formula for x<, one for x> Unsure of my problem
  234. copy each name only ones
  235. question about a formula
  236. [SOLVED] If statement formula question
  237. IF statement...
  238. Referencing directory from inside function
  239. Manipulating Date Flags
  240. Conditional Formatting misbehaving? Or is it me?
  241. Using FILL command for a formula
  242. Increment within a formula
  243. Count the number of records conditionally
  244. Can you use a Pulldown in Pop Up w/database
  245. Using multiple IF statements
  246. font color
  247. Sumproduct help - CLOSED Thank You
  248. Compare data in worksheets
  249. Cell info within a given range
  250. Doing a YTD sum - vlookup?