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. Eliminating blank cells in a list on a ROW
  2. How do I fill the upper or lower half of a cell with color?
  3. significant digits for decimals
  4. Adding a column that used X's
  5. Finding a value within two rows
  6. Time stamp that does NOT update
  7. Printing in Excel2000?
  8. "IF" function - 7 nested limit
  9. Counting the number of times a specific character appears in a cell
  10. Locking linked cells
  11. VBA Code To have a macro repeat on all sheets in a workbook
  12. Can I set up a sort by clicking on table a heading
  13. checkbox?
  14. how to format Doe,John to Doe, John (space after a comma)
  15. matching the column b(sku)c(count)with A
  16. IF Function
  17. Has anyone successfully used NETWORKDAYS with arrays?
  18. Income Tax Payable from table with escalating marginal percentage rates.
  19. How can I using Excel custom document properties in the header?
  20. How do you link 2 drop-down menus?
  21. what is the maximum number of vlookups in a given workbook that E.
  22. Update one spreadsheet and reflect on another
  23. Is there any "autonumber" in Excel?
  24. Help with IF Statement
  25. Links only update when external workbook is open
  26. external import of multiple worksheet data & create pivot table
  27. macro for new sheets
  28. How do I display colour on my EXCEL spreadsheet?
  29. Dates in Excel
  30. IF formula works one way and not the other
  31. create a list of single values from multiple values
  32. Add a unique formula
  33. overcoming nested IF limitations...with VBA?
  34. excel spreadsheet into address labels
  35. isolating different aspects of worksheets...as objects? through section breaks?
  36. PLEASE HELP
  37. how can I get the name of the active worksheet?
  38. Referring to Cells in a forumula using a function
  39. =if(and(....
  40. Limiting the range of a lookup function
  41. Comparing and Merging data
  42. create reference formula that looks through all sheets for matchin
  43. Is there a pull down Box to alert for minus balance such as ($5.00
  44. drop down box
  45. Number of hours worked between 18:00 and 06:00
  46. could someone help!
  47. simple MAX + comparison formula
  48. Want #VALUE! to show as blank cell
  49. RSQ function gives incorrect result
  50. How to add an ActiveX control in Excel?
  51. Mathematical explanations/equations for Excel functions in "Help"
  52. Excel formula that sums if meets two requirements.
  53. Count cells with strikethrough font?
  54. excel formula to enter "0" if cell blank
  55. How can I correct this Time formula
  56. Range used in a macro needs to be variable
  57. Excel Holiday Roster Calender
  58. date format
  59. Ordering fields formatted YYYY Mth in a Pivot
  60. Pulling in the path to a filename
  61. How can I include bmp file in excel 2000 header?
  62. How do you Stop Entering Duplicate Data in a Column?
  63. How do I get my worksheets to print in the right order?
  64. Creating a list in sequential order
  65. Average given criteria, HELP!
  66. How to blank a cell with a formula
  67. Array formula help please
  68. linking sheets
  69. how to change a color of cell 2a to blue if 2b contains a value?
  70. Conditional Format (month and year) = Today()
  71. How do I count a named range for a specific word or acronym?
  72. How to calculate the RATE in annuity?
  73. Excel: custom header - is it possible to paste into header?
  74. how to calculate commissions
  75. Converting numbers to text
  76. I am trying to set up a spread sheet to enter some real estate dat
  77. how to do a spread sheet
  78. Today() & Now() function
  79. Sumif
  80. The conditional format function
  81. Getting Excel to Calculate All Combinations of a Set of Data?
  82. sumproduct based on format
  83. Find a "9" within a range using a function (T/F)
  84. Using MAX to reference a row
  85. Confused beginner
  86. Excel puts a 0 at the end of my number
  87. adding rows of hours and minutes to get a total
  88. problem using "<=" with SUMPRODUCT - PLEASE HELP
  89. Hyperlink Formula to call up browser
  90. separate worksheet into multiple worksheets by grouping
  91. subtotal
  92. right function on pasted link
  93. NETWORKDAYS question
  94. Cell reference in diff worksheets
  95. Conditional Formatting
  96. Beyond Conditional Formatting...
  97. question about SUMPRODUCT
  98. unable to open file
  99. Hide text in shaded cell
  100. Formula writing problem
  101. Function to return last entry in a column series?
  102. column and row headings
  103. IRR Guess Problem
  104. don't allow users to assign the cntrl+s as a short cut for macro
  105. Converting functions into numbers
  106. excel input 0 when cell blank or deleted by key or spacebar
  107. Some rows sort incorrectly in Excel. How do I correct the problem.
  108. how can I fix a #value! error?
  109. YEAR and MONTH confusion
  110. Finding Min Cell values excluding zero in alternate columns
  111. Reference Formulas
  112. linking columns
  113. After adding Analysis Tool Pack, still no PRICE function, why?
  114. I need to combine 30 columns into 1 or 2
  115. How to return a value Referring to the other cell.
  116. How to highlight a row containing specific phrase?
  117. Data from one sheet to another
  118. how to lookup a value and return multiple corresponding values
  119. Workingday Calculations
  120. how do i sort by numerical prefix ? 1423 would come before 850
  121. How to add date format into if statement?
  122. HELP on COUNTIF
  123. Problem sorting cells containing hyperlinks
  124. Auto Selecting Cells
  125. Lock row in Excel
  126. change the colour of text in cell for minus figure
  127. Percentages
  128. Bessel function/directivity function
  129. Setting up a fiile/template to generate a new number when opened?
  130. Finding Bad Web Queries
  131. Dynamic Average
  132. MATCH Limitation?
  133. How to make data in one workbook appear automatically In another
  134. Re: problem with #value!/zero
  135. mortgage calculator formula
  136. Creating a league table based on results
  137. range of cells from + to -
  138. want sumif function's range to evaluate 2 columns
  139. E-mail sent for a cell in a sheet that lists a birthday as today
  140. In 2 Excel worksheets, I am trying to eliminate duplicate entries
  141. Why have my Excel Macro Shortcuts stopped working?
  142. How can I use the same validation for an entire column?
  143. Merging Text Help
  144. event macros - xl 2003
  145. How to Append the Data to the Master Table
  146. Average, IF
  147. I WANT TO ADD A TWO RANDOM CHARACTER SEQUENCE TO A SET OF ROWS
  148. Vlookup worksheet function
  149. Conditionally Fill a sheet row if cell value in another sheet >0
  150. conditioning
  151. How to add auto remender in worksheet
  152. How do I merge 2 excel spreadsheets containing some common info?
  153. Need cells to show as zero or empty
  154. counting 0 in a row
  155. Counting Age
  156. Look up a list of prices
  157. pricing problems
  158. Conditional Equations in Excel
  159. RE: need a function to calculate a mortgage payment
  160. conditional subtotal counting
  161. need a function to calculate a mortgage payment
  162. Formula Help
  163. Complicated IF Formula
  164. How do I lookup a corresponding value in another table
  165. Columns with "zero" width
  166. HELP ME PLEASE
  167. import external data too many rows for one worksheet
  168. CHK file in excel link files
  169. {=AVERAGE(IF((C3:C325<M4), C3:C325))}
  170. "Rows to repeat at top" option under page setup
  171. VLOOKUP Problem (limitation)?
  172. Formula which splits principal & interest pmts on P&I Loan
  173. rows that need deleting
  174. Does Correl/Rank combo work eg CORREL(cols E & H) where E&H=RANK(.
  175. counting text
  176. How to generate a list of randomly selected numbers within a range
  177. Non-Blank Cells: Conditional Counting
  178. Need to derive combinations for 4 elements each with 3 possible va
  179. Text moving
  180. How many IF are authorized?
  181. Change text within multiple functions
  182. Multiple IF
  183. Complicated counting of cells (based on other cells contents)
  184. Help w/ counting multiple columns based on IF criteria
  185. Protected sheets and cells
  186. Calc Diff Between Two Julian Date
  187. Drop-down boxs
  188. Logon Screen
  189. Protect Workbook vs Worksheet??
  190. Can you create a formula to add 1 to the # you enter
  191. Delete Formula
  192. Searching for a particlar value and matching to a name..
  193. IF statement containing OR
  194. Comparing Lists
  195. Excel columns do not add correctly.
  196. Worksheet name in function
  197. How can I display a "sliding" range?
  198. Calendar - vlookup based on dates
  199. Time Sheet frustrations
  200. how do I use if formula using dates?
  201. Can an Excel Spreadsheet automatically sort new data?
  202. splitting names can't see whats going wrong (Save My Sanity )
  203. Re: splitting names can't see whats going wrong (Save My Sanity )
  204. extract name when a date in another cell gets near
  205. How to Count Rows with defined values in multiple columns
  206. Autofilter with Subtotal Sumif
  207. Formula Help
  208. Is it possible to insert a macro command in an "IF" function?
  209. lookup tables
  210. dynamic summed range based on a variable
  211. Need help creating a formula to summarize data!
  212. Count and Sum cells with certain format (e.g. color)
  213. Average with a 0 in the equation
  214. Statistical help file
  215. Vlookup doesn't work until i edit(but not change) the lookup cell
  216. can we round time in excel
  217. How can I add data analysis function in tool?
  218. Re: Excel macro
  219. Can someone give me a hand with this formula please?
  220. How to AUTO SORT A-Z new data in a column (not menual sorting)
  221. Autofilter stops responding
  222. Excel Crashes
  223. How to display weeknumber with year code
  224. Worksheet Names
  225. Help with schedule layout
  226. how to automatically convert a number to words in Excel
  227. Function IN VBA
  228. Consolidating data??
  229. assigning rows
  230. two cases for countif
  231. Need a Formula for DATES
  232. What function can I use
  233. STRING functions
  234. Worksheet tabs in a Macro
  235. vlookup, multiple values, sum values into one cell??
  236. How to copy 98-97 excel macros to excel 2000 (XP)
  237. Can't make Excel "if" Formula work
  238. Using Autofilter with Protection on
  239. How do I clear data values wthout losing the formulas?
  240. Renaming and saving workbooks but macro still deletes
  241. Help with Date Functions
  242. How to I get a warning message box
  243. Get tab name formula
  244. excel 2003
  245. SSN Format not showing
  246. Copied nubers is not possible to add
  247. How do you count data that matches more than one condition?
  248. How can I change dafault color in excel from black to another?
  249. How do I change my cell reference columns from number to alphabet?
  250. sum
Google