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. hOW CAN I CONVERT NUMERICAL POINTS INTO A LETTER GRADE(SCHOOL)
  2. How do I create a number format mm:ss:th (tenths and hundreths)
  3. insert two formulas one cell
  4. How do you make a countif formula with 2 or more critera?
  5. Excel won't save
  6. Permutations
  7. Permutations
  8. Conditional Formatting
  9. SUMIF help!
  10. a unique cell value returns multiple cell values from another shee
  11. how do I make single character as a variable in an array
  12. How do I make FORMULA TO SOLVE CURVE OR 2ND ORDER EQUATION?
  13. I TELL A CELL =B1 BUT I ALSO WANT IT TO TAKE THE TEXT COLORS
  14. Permutation in excel
  15. maxium worksheet on a workbook?
  16. Advanced Filter is grayed out
  17. return value based upon another
  18. Pivot table page filter not accepting multiple values. Workaround?
  19. sharing entire columns
  20. formula ignores last infor - please help
  21. HOW DO YOU ADD & SUBTRACT IN ONE COLUMN
  22. count cell if value present in every other cell + criteria
  23. Excel 2000 Question
  24. VLOOKUP - computed go to
  25. How do I use Excel to do a Gage Repeatability and Reproducibility.
  26. Converting cell ref. w/num to currency
  27. Problem with nested logical formula.
  28. Insert New Row without shifting formula
  29. A borrowing dvd spreadsheet
  30. "B/."
  31. HOW DO I CHANGE QUERY DATA TO A DATE RANGE?
  32. how can I match numbers from two columns?
  33. how can I match numbers from two columns?
  34. New Worksheet
  35. Advanced Filters
  36. Interrogating cells by cell formatting
  37. y i cannot solve it ?
  38. How to set a column to accept only a specified number of digits
  39. bahttext
  40. Straight forward idiot question!!!
  41. How do I create conditional formatting to track due dates
  42. Index and Match Help Needed
  43. Prevent entry in a column
  44. Excel Macro Hide
  45. simplify a vlookup function
  46. How to sum cells with a certain letters sequence
  47. Include Subtotal in SumIf
  48. Req: How to create multiple mutually exclusive filters
  49. adding lots of cells from different sheets
  50. CONVERTING TIME (DAYS) TO ONTHS,YEARS, ETC.
  51. Returning Descending Values
  52. Array Formula Calendar
  53. feet and inches
  54. Excel Function
  55. Last cell entered
  56. Return Value
  57. Conditional SUMIF
  58. date in file name
  59. How do I change a range name back to the underlying data range?
  60. combine 2 columns
  61. IF formulas
  62. Range of Cells to create body of email
  63. Division By Zero
  64. Vlookup formula - Excel Version 2002
  65. Formula format for Count or Countif funtion with two criterias
  66. Is there a way to stop fractions from being simplified?
  67. Excel-read a table
  68. How do I clear the contents of one cell from another cell?
  69. How do I rename the A B C cell range along the top of excel
  70. cell on one page equals cell on another page in excel?
  71. Comparing columns iin 2 sheets to generate one
  72. Count and Count if funtions
  73. RE: Forcing Cell Entries to be Upper Case
  74. have a calendar pop up in a cell to pick & insert a date in excel
  75. Countif statement
  76. Just need to know what type of formula i would use for this
  77. Can Excel2002 determine if a calculated date is a business day?
  78. Can a date be used for conditional formatting?
  79. percentage increase
  80. Sumproduct..help please
  81. IF Statement - Excel Version 2002
  82. Can I put more than 65536 rows in one Excel sheet?
  83. enter month end date
  84. Need help w/dates
  85. Amount of Increase of Wages
  86. Formula
  87. If functions for dates
  88. Is there any easier way to do this formula?
  89. radio button help
  90. real-time countdown
  91. What is ROW(INDIRECT("1:40")) doing? (array formula)
  92. Excel, renaming columns
  93. Scenarios
  94. Position of a cell in a range
  95. Return value of the cell to the right...
  96. Delete Define names across workbook
  97. How do I show a timestamp when an adjacent cell changes in value?
  98. Display the results not the formula in the task bar
  99. Budget
  100. formula for cell merging
  101. How to insert a barcode into an Excel sheet cell?
  102. Parsing 124A into 124
  103. Parsing 124A into 124
  104. Getting value of Option button
  105. Coloring Active Cell
  106. Please help!
  107. Looking up text - help
  108. How do I repeat a value in a pivot table in Excel?
  109. radio button help
  110. How do I eliminate the leading zero when concatenating?
  111. Is there a way to isolate individual cells?
  112. Counting unique records with additional criteria
  113. VLOOKUP loop multiple times
  114. Match/Index return #N/A
  115. Help with a function
  116. How do I identify cell color for comparison?
  117. Automatic update to cashflow spread sheet
  118. Macros? drop downs?
  119. Advanced IF function
  120. Excel 2003 Mouse Right Click
  121. countif date range
  122. my date range does not work in an = ifsum
  123. i want to calculate the houers of workers 21:00 - 05:00 =8
  124. How do I display a formula on the worksheet
  125. LOOKUP(?) Challenge
  126. Protecting Macro's
  127. Excel should let me change case in the cell the text is in.
  128. How do I delete a drop list button
  129. Cellphone tariff checker
  130. macro to hide columns
  131. linking data from one workbook into another
  132. IP Address in cells
  133. how to change a formula for a large group of cells
  134. AutoSave: How can I get it to save every 5 minutes & NO prompt?
  135. VLOOKUP across merged cells
  136. Find 7....
  137. I need to protect cells that contain formulas but on a huge scale.
  138. Database functions should use criteria in formula, as 1-2-3 does
  139. Calendar 1st month ok but 2nd to 12th how.
  140. date ?
  141. autosave
  142. how do i create a formula for selected range?
  143. Help with averages please
  144. array formula problem
  145. Data Automation Transfer
  146. calculating entries
  147. Is there a macro which adds selected/highlighted cells?
  148. if (and) question
  149. COUNTIF and multiple conditions
  150. how to do it without rounding off
  151. Re: Calculating p-value from Fisher's Exact Test
  152. any function or mechanism to get in a cell the name of the sheet?
  153. calculation with minutes
  154. How am i able to populate a sumation for multiple sheets
  155. Counting by multiple criteria
  156. convert dates to number of days
  157. Print "Landscape" in Explorer
  158. password
  159. Autofilter number of records
  160. sumproduct resulting in #N/A
  161. How can I round up a fraction?
  162. how do i tranpose one row to multiple column?
  163. CountIf Question
  164. Summing a Range Omitting the Occasional #N/A
  165. Extracting integers from a text string.
  166. SUM Querie
  167. How do you have the file path print on all pages?
  168. How do I calculate and display ratio ( format 3.5:2)
  169. Networkdays
  170. I can't get the Erlang formula in Excel 2002 to populate...help
  171. How do you randomly sort a RANGE
  172. Help with vlookup formula
  173. Logical Function Question
  174. return a value based on a range
  175. Any tips besides ALT+ENTER?
  176. Re: transpose
  177. SUMIF function with 2 conditions
  178. visual basic
  179. need to show when date is past due
  180. pasting formula doesn't work
  181. VLOOKUP results on last names
  182. conditional formatting
  183. How do I create a unique identifier # when open excel file?
  184. Can I use Excel to match text data from 2 separate columns ?
  185. Copy formatted in several sheets of a workbook
  186. Is it possible to use a wild card in a =COUNT(IF equation?
  187. percentage
  188. what is the maximum no of formula's in 1 spreadsheet?
  189. cannot delete contitional formatting
  190. Most simple formula to calculate date+ 30 months?
  191. summarize data sheet
  192. simple
  193. Does 2003 excel have training on V Lookup
  194. Get Past the 7 Nested IF limit
  195. how do I hide data elements in pivot in excel 2003 ?
  196. Sum unique with conditions
  197. Find data in columns, then place in rows
  198. macro to hide rows if cell is blank
  199. repeating functions
  200. Database type formula
  201. how can I eliminate the first 3 characters from a cell
  202. How do embbed a cell within a sentence
  203. How do I insert OR in imbedded formulas?
  204. Help with averages please
  205. countif
  206. cell color
  207. sum values in a data group
  208. VLOOKUP 2 text columns
  209. Sumif and base it on font color of cell
  210. Excel
  211. Text won't wrap if row height is over 200
  212. Need Elapsed Time Help
  213. repeating a character across the width of a column
  214. column from ABC to 123
  215. Re: List of Names, Dates, Durations ...
  216. Error when opening a saved worksheet
  217. keeping certain values the same when copying
  218. Convert SERIAL date back into dd/mm/yy format?
  219. vlookup to provide row reference instead of value
  220. How do I calculate the difference between 2 dates (m,d,y) ?
  221. Data range to names
  222. SUMif or SUMproduct across multiple worksheets?
  223. COUNTIF doesnt work!
  224. vlookup with more than number to be retrieved
  225. conditional formatting
  226. Random numbers generation with conditions.
  227. how can I combine multiple worksheets into one?
  228. Excel-comments entered by users disappear in a shared excel-sheet
  229. Simplifying array formula which evaluates as error.
  230. IF + AND string - Help!
  231. random number function
  232. decimal to binary conversion
  233. ROUNDING
  234. IRR
  235. cell shading
  236. How to create list on another tab by selecting qty from big list?
  237. Create different workbooks from only one workbook
  238. Changing orientation of pages
  239. random number generation
  240. Remove last character of text string
  241. How do I change fill color in excel based on data in the cell
  242. how to display remaining rows as blanks
  243. How do I add a cell with a label behind it
  244. How do I retrieve deleted information from an Excel worksheet?
  245. countif problem
  246. days caculation
  247. Sum Dates
  248. Pivot Table Question
  249. Rounding Data Question
  250. Count names in column once
Google