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. Help matching entries in two sheets???
  2. macro button in all my workbooks
  3. Protected sheets
  4. SUMIF function question
  5. How do I set up an IF function with text and numbers?
  6. If Function
  7. How can I generate correlated standard normals?
  8. 2nd attempt ~ complicated formula
  9. Another #N/A Result question...Sorry
  10. strange error calculations provides errors until i add any new one
  11. Using Two Worksheets To Capature Data
  12. Weighted avg of numbers not in contiguous row-ie array w lookup?
  13. Conditional Formatting
  14. Can I create a random order within a series of numbers in Excel?
  15. Excel multiline formulas
  16. how to apply one function to an entire column of numbers
  17. How do I convert time (38:30) to decimal (38.5) format?
  18. LOOKUP
  19. Nested IF's with Rank Problem
  20. Creating Combinations
  21. using the same function to convert a column of numbers
  22. $$$$$make tons of cash EASY$$$$$
  23. populate data valadation list by criteria
  24. Value error
  25. function problem
  26. is it possible to make a spreadsheet display '0' when negative
  27. Taking data from another worksheet and converting
  28. hyperlink to files
  29. How do I select & use contents of first non-blank cell in row?
  30. How do I turn off the solver results dialog box
  31. Showing the contents of a cell based on another cell
  32. editing spreadsheet
  33. Expanding data
  34. ... I would like to apply more than 3 conditional formats ...
  35. Excel data base
  36. shortcut for merging selected cells would be nice.
  37. Concatenation in a CountIf
  38. Macro?
  39. How to change reference to other worksheet by changing one cell?
  40. Excel
  41. How do I have a data table display cell names rather than values?
  42. Substitute ,replace and delete in a cell.
  43. skipping every second cell
  44. Seting up an Indirect Formula
  45. include INDIRECT function into SUMPRODUCT formula
  46. how to create a conditional formula for a range of cells?
  47. "s Appear in files saved as Text (MS-Dos)
  48. How do I sum percentages calculated from IF statements?
  49. Excel find the content of cell using row and column header
  50. Dissappearing formula
  51. comparing many cols of data to one col
  52. Search for instances of X in a sheet
  53. trend for polynomial curve fitting by regressing
  54. How do I change hexadecimal number to binary in excel
  55. Transpose rows to columns w/varying numbers of lines per record
  56. Function for interest rate over several years
  57. LOOKUP function
  58. Footage to seconds (# to mm:ss).
  59. Referencing cell in another sheet yields null?
  60. the answer to appear in more than one cell
  61. templates
  62. IF/AND/OR/DATEIF Issue...sorry...long post...
  63. how do i add every fifth row in a spreadsheet?
  64. Sub-Totaling
  65. Formula is entering a default time when it comes across an empty cell..
  66. How can you convert the false/true into 1/0 in Excel?
  67. Blank Printouts and Print Preview
  68. max and lookup
  69. Delete rows listed less than 8 times???
  70. Conditional Formatting
  71. Select random cell
  72. Multiple SUMIF Criteria
  73. This is so silly...
  74. Date/Time Question
  75. Count number of different entries?
  76. RANK Funciton
  77. RE: CONCATENATING DATE AND TIME
  78. How do I calculate pro-rata formulas?
  79. time/date calculation
  80. Cell reference to current cell minus 1
  81. Can I limit the amount of characters in a cell?
  82. in excell the cell only displays formula, not the number
  83. CONCATENATING DATE AND TIME
  84. password protection
  85. function problem regarding cell range
  86. How do I get LINEST to show all stats?
  87. Counting similar text
  88. Re: Lookup across multiple worksheets
  89. Change event fails to work
  90. How do I create a list from a large spreadsheet without headings
  91. COMPUTING TWO COLUMNS
  92. how can I have Excel total a column of # that were derived by form
  93. formula QUESTION
  94. PIVOT Table
  95. Format cell to show numbers in words
  96. Help I am going crazy with this formula.
  97. transposing links
  98. Showing + and - (show and hide) for rows in the sheet
  99. combobox not working
  100. Calender Help
  101. I have alot of text in a cell, I just want to see the top line
  102. IF statements and moving data to different columns
  103. options to update automatic links
  104. pivot % or column tinkering
  105. Alternative to multiple IF limits
  106. Replacing Values in Cells Via Formula
  107. How can I keep a fraction from being reduced?
  108. Hour Sum
  109. How do i count numbers and letters to find a total count of all
  110. Worksheet template
  111. macro save a workbook whilst increasing file no
  112. Width of drop-down menus
  113. Excel student/teacher edition 2003
  114. Problem with adding time values
  115. Is there a function that gives us the last day of a month
  116. Is there a function to give us the highest value in a list of tex
  117. cheapest price
  118. In Excel can you add cell A2:A10 that only have text
  119. UDF Add-in New category in "Paste Function Dialog Box"
  120. Can "IF" function display calculated data as bold?
  121. Reverse numerical values
  122. CF in a filter
  123. SUMPRODUCT
  124. IF STATEMENT PROBLEM
  125. How do I change how cells are sorted in an excel file?
  126. Re: multiple conditions formula
  127. Confusing VLOOKUP with Indirect reference
  128. Formula for markup won't change when the initial value is changed.
  129. Checking for duplicate items in list
  130. Changing Cell Color
  131. countif condition problem
  132. Using IF Function with EDATE Function
  133. Formula to compare two lists and separate non-recurring items?
  134. How to set the "to value" in GOAL SEEK as a cell reference?
  135. autofilter freeze
  136. SUMIF question with multiple criteria
  137. Columns in excel 2003
  138. how do I insert a blank row when a value changes, automatically
  139. spreadsheet spanning 4 weeks
  140. IF COMMAND WITH TEXT
  141. How do I compare excel spreadsheets, tracking the differences?
  142. prevent empty rows from printing
  143. IF/THEN Average Problem
  144. how to perform a deduplication of names on large mailing list
  145. Spreadsheet will not sort
  146. ##value error
  147. Preventing new worksheets when drilling down in PIVOTs
  148. saving documents with macros
  149. sum>1 --> count = count +1
  150. questions being addressed
  151. how do I count the numbers of row that meet 2 criteria
  152. Timesheet maximum hours problem
  153. FIND FORMULA SIMILAR TO VLOOKUP FOR NON-ASCENDING VALUES
  154. matching and lookup??
  155. Re: multiple conditions formula
  156. Formulas across worksheets do not update
  157. Location of the last "s" in a text string
  158. AVERAGE(IF()) problem
  159. Spreadsheets with multiple entries
  160. regression
  161. linest r-squared bug when calculating forced through zero?
  162. Conditional Statement in Charts
  163. Building Formulas
  164. With formulas does anyone know the order of precedence BOMDAS
  165. Add seperate Items.
  166. Match help
  167. Linked Combo Boxes
  168. 2nd attempt ~ Faster/Shorter formula
  169. ISNA(MATCH...) and IF functions - can they be combined?
  170. need help with determining a formula
  171. Extract Unique Records from two lists
  172. a formula that leaves cell "empty"?
  173. creating hyperlinks
  174. Show timesheet time in and out in regular time versus military tim
  175. SUMPRODUCT
  176. Matching data from seperate excel files
  177. workday date function
  178. Excel Function returning negative 0
  179. Reformatting dates as text
  180. Colour full row in CF
  181. cell values not updating
  182. Conditional SUMIF???
  183. various values and listing them
  184. filter arrows showing when copy and paste to powerpoint
  185. best way to get reference to all used cells
  186. How to delete all defined names from a workbook?
  187. I need to link only certain cell...
  188. Validate drop down box
  189. extract year
  190. How to print from consecutive numbers in excel w/o typing all?
  191. Multiple Range Pivot Table
  192. Input Range for a List Box
  193. Using formulas/functions
  194. How do I copy information to the ascending by LName worksheet?
  195. Excel dates change
  196. Lock and unlock cells conditionally depending on input in another
  197. Formula Question
  198. Nesting SUMIF formulas
  199. Alternate Menu Shortcut
  200. How to use "CONCATENATE" function in VBA
  201. Auto recalculate?
  202. drop down for excel?
  203. Linking worksheets
  204. Pivot Table Question
  205. how to calculate overtime automatically on Excel timesheets
  206. Grouped Worksheet and Protection
  207. Help with date formulas in Excel
  208. Excel subtotals cells with a formula - HELP
  209. How do I convert an entire sheet from columns to rows?
  210. How do you use the > < funjctions when calculating negative numbe
  211. Creating a Formula
  212. IRR Calculation issues
  213. Change cell colour
  214. Time Accrual; Negative balance
  215. How do I select every 5th row within a list?
  216. percentage
  217. Workbook copies itself when opened
  218. VB??.tmp error with multiple excel worksheets in 1 book
  219. Sorting data by Date
  220. Finding last value greater than 0
  221. Reference question
  222. Count Text in a Cell
  223. Swapping rows and columns
  224. Custom Menu Help
  225. Preventing Macro Flash
  226. Newbie needs help with incrementing a series of cells
  227. How do I add a symbol between numbers in a column?
  228. Can I randomise the order of a number of rows?
  229. how to add 17.5% vat formula
  230. Individual calendars for 30 employees
  231. Dynamic Range and arrays
  232. plot
  233. VLOOKUP? Need to have value returned when select from drop-down list
  234. Find a character to sort on in an Excel cell if not the 1st charac
  235. Footer... Entering Serial Nos and incremnting daily
  236. how to add 0 before a number for ex 2344→02344
  237. Excel CELL bug
  238. Financial Functions
  239. Recalculation taking a massive 11 seconds
  240. Recalculation taking a massive 11 seconds
  241. £1.5m to 1.5
  242. Formula to copy rng of cells where (value is met) to anther sheet
  243. VLOOKUP function
  244. looking for latest selling price..
  245. Add excel horizontal & vertical ruler
  246. How to connect two columns in Excel VBA??
  247. Function newbie
  248. text to number
  249. How can I use autosave from excel2000 in excel2003
  250. is there a function for getting the content of a cell?
Google