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. Adds City but not Panmure ( Combined Total )
  2. How do I delete duplicate cells?
  3. Excel Formula - to calculate highest number from a set of numbers
  4. VLookup Problem
  5. Set a date and have other cells reference it and incease monthly?
  6. Date ranges in a sum formula
  7. Multiple Arrays, Vlookup
  8. Insert document properties in a cell
  9. Sort rows by keyword
  10. Question about the =NETWORKDAYS FUNCTION?
  11. Excel Formula Question
  12. Measurement Convertor
  13. Sum Product Function Maybe
  14. using excel to calculate loan amount.
  15. counting occurances
  16. Allow users to edit ranges for VBA objects
  17. Dropdown list width changing code
  18. Getting only the filename with no extension
  19. change font color if number Range changes
  20. formula for changing CAPS to small letters
  21. inverting data for a graph
  22. Comparison of records between two spreadsheets
  23. Finding the Right Formula
  24. I used to have the WEEKNUM fctn in excel,now it's not there, why?
  25. Combining references
  26. Can you use 2 look up values in VLookup?
  27. summarize data from one spreadsheet to other spreadsheet
  28. SumIf query ...
  29. Sumproduct question
  30. Prevent changing size when copy&paste into another Excel Worksheet
  31. Help with hyperlinks in pulldown list. Anyone know how?
  32. converting spreadsheet info onto mailing labels?
  33. Function Problems
  34. Live links - Excel to PDF??
  35. Trim if?
  36. How do I delete formulas but save numbers?
  37. Display/formula help
  38. how do i display a variance in all positive numbers?
  39. Formula Editing
  40. how do i display a variance in all positive numbers?
  41. Formula Editing
  42. help-sum filtered info on excel for more than one filter
  43. How do I create a cross section between two columns?
  44. why do i get ###### in cells
  45. Cell Referencing?
  46. Hyperlink Woes - Please Help!!
  47. Formula question
  48. excel 2003 question
  49. Date referencing
  50. If two cells have specific text to count as 1
  51. Replace double spaces with Hard return
  52. questionnaire in excel
  53. CONDITIONAL FORMATTING BASED ON RESULTS IN A CELL
  54. how do I do a global replace in all sheets in a workbook?
  55. Help - Pivot with multiple variable
  56. Select Minimum value and return the name of the supplier
  57. World Cup tipping
  58. Vlookup? Referencing cells?
  59. Making multiple selections from Excel drop down lists
  60. Problems with sumproduct
  61. Checkbox and Satic Date
  62. Help with IF
  63. Subtotals at different levels in nested table
  64. Excel data import problem
  65. tier pricing
  66. array formula with a dynamic range.
  67. lookup
  68. Pulling information from a list
  69. Adding a Number value to Time
  70. How do I get data from a cell on another worksheet?
  71. Inventory
  72. How do I sort data with multiple conditions?
  73. How do I get the diagonal of a matrix from excel?
  74. Quotation Marks?
  75. Counting
  76. Now With Index -- IF Function Does Not Work With Cell Reference
  77. summing values in one row based on values in another row
  78. countif on unformatted dates
  79. inserting worksheets
  80. IF Function Does Not Work With Cell Reference
  81. Interpolating an x, y point from known x's and y's
  82. INCOME TAX DEDUCTIONTIONS
  83. Function to give previous month
  84. VLOOKUP
  85. Nesting and Naming help!
  86. HOW DO I SET DATES TO SHOW ON MY SPREADSHEET?
  87. How can I convert This
  88. Sorting a subscription list
  89. repost from general area ref values with column to left HELP
  90. rooms checklist
  91. External Web Query Errors
  92. AVERAGE function
  93. Formulas in Excel
  94. Overcome LOOKUP limits and NOW()
  95. formula assistance - percentage difference
  96. Cell format problem after copying
  97. sumif to return an intersection?
  98. sum() using indirect()
  99. Add Column Data with Twist
  100. Importing CSV data
  101. Format Question
  102. Do not propmt to save data on exit
  103. SORTING DATA
  104. Data Entry
  105. Is this designed for Offset Function?
  106. count number of cells in range showing between 320 and 345
  107. Tough one - Sum and IF with multiple referencing (array)
  108. how can I install the offic assistant to my system
  109. imported data into excel
  110. Numeric copied from webpage can't be recognised by Excel
  111. i need to know how do we make multiple bar chart in EXCEL
  112. Looking for a site with functions that substitute the ATP functions
  113. formating
  114. even spacing in a dropdown list.
  115. Creating an array to find months
  116. Email button???
  117. Wacky IF Structire
  118. convert time to numerical vale
  119. Need to average a range AND calc a formula at once...
  120. How to code Macro for hiding rows
  121. Now how to delete plurals??
  122. Project Management - Start & End Date Calculations
  123. Automatic Page Breaks
  124. Something Like a Multiple Look Up
  125. How do I remove automatic page breaks?
  126. function in to make text plural?
  127. macro to filter out data
  128. Need to make text plural??
  129. How to use condiational validation choices in same column?
  130. Vlookup to the left
  131. How do I make this happen
  132. How Do I find/replace a blank cell with a formula?
  133. How I view information requested from a combo box?
  134. Can I protect an Excel spreadsheet, and use Outline functions?
  135. Diabling Hyperlinks in a Spreadsheet
  136. Macros
  137. When I clear a print area, it still prints.
  138. Copy text from text box to cell in another worksheet
  139. How do I??
  140. Countif question
  141. Replace using Wildcards
  142. Conditional Format based on other cell's value
  143. SORT REPETITIVE DATA FROM ROWS TO COLUMNS
  144. using excel generate random numbers 1 to 52 without repeating
  145. Greeting Function
  146. How would I add an extra column in a spreed sheet
  147. 2 criterias for countif -
  148. getpivotdata
  149. Is it Possible?
  150. Deleting macros
  151. COUNTIF problem with NOW()
  152. IF statement question
  153. Vlookup for multiple values
  154. Paste special values but not...
  155. Filtering
  156. List File Properties - Author
  157. How do I work with variances when there is a negative number?
  158. insert date
  159. Is there a function for this....
  160. Conditional Identifiaction Of Unique Entries
  161. Counting colour formatted cells
  162. Calculate only Positive Numbers
  163. Random funtion
  164. Trying to Capitalise on Input to Cells
  165. Lookup sort of thing!
  166. Hiding rows on condition
  167. How do I automatically compile totals from 12 worksheets into 1?
  168. Converting Day Numbers to Dates...
  169. How can I add IF statements
  170. Inserting a worksheet name into the worksheet
  171. What's wrong with this Match formula
  172. finding repeated numbers
  173. Data Validation - List - Data "NOT BETWEEN" - Source Possible?
  174. Numbering Duplicates
  175. Worksheet from Formula
  176. To display contents of a folder in an excel sheet using Excel MACRO
  177. Date and Text in one formula
  178. Replacing sheet reference in multiple cells...
  179. Generating list
  180. RE: insert 2 colours in a single cell,corner to corner
  181. Sorting names and numbers in order with the highest total
  182. Calculating total time
  183. column is hidden in normal view but not print view
  184. Linked values not updating
  185. want a formula give total quanitity break up frm other sheet
  186. how to trim a whole excel sheet?
  187. lookup values
  188. Help with points sheet
  189. have invoice # roll up, or add 1, each time document is opened
  190. Solving for multiple algebraic variables
  191. conditional formatting
  192. Print Area. 1st page Landscape 2nd page Portrait??
  193. IF statement help
  194. Create multiple sheet tabs from multiple cells.
  195. count rows that meet two criteria in two different columns?
  196. I need help with a formula for cricket stats!
  197. How do I include filtered out numbers in a SUBTOTAL?
  198. Convert a number to a name string
  199. Formula with conditons
  200. Text To Column
  201. Sumproduct
  202. Performing Multiple Functions in a Column
  203. named ranges
  204. Custom Header Error - Too Many Characters
  205. Excel hyperlinks not live in PDF document
  206. How do I used a big formula I created in Excel?
  207. Date plus 1 year (february problem)
  208. How do I anchor hundreds of cells easily
  209. how to repeat text on sheets in excel
  210. xirr
  211. display and count the number of times a value appears
  212. can a pivot table pull from multiple worksheets?
  213. xirr
  214. display and count the number of times a value appears
  215. can a pivot table pull from multiple worksheets?
  216. logic (IF) functions
  217. Function to return # of column with min value in selected rows
  218. Searching on Dates
  219. summing columns if there is data
  220. Advanced Filter not working
  221. MAJOR BUG: Excel operator precedence is wrong
  222. Show hash marks instead of text
  223. SUM Range based on date
  224. Hiding rows if specific cell does not contain key word
  225. AND function?
  226. Index/ Match Formula
  227. xirr function
  228. Range Names
  229. Highlighted Reference Cell for a Working Cell
  230. Using cell content to access another worksheet in same workbook
  231. Help with IF Statement
  232. Nested If problems
  233. Link and fill cells in workbooks
  234. "IF" Formula
  235. Trouble with selecting multiple ranges of data
  236. How do I copy formulas but using the same range each time I copy
  237. VBA Code help
  238. I want to turn off research task pane forever.
  239. pivot table field summarize default
  240. urgent help
  241. Number of Sheets in a workbook formula
  242. Rows Insertion
  243. Extracting 1st 3-digits of postal code that begin with 0
  244. Rows Insertion
  245. Rows Insertion
  246. How can I determine the largest physical size cell in a column
  247. Validate before running macro
  248. Validate before running macro
  249. Validate before running macro
  250. Phone Number formatting