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. Timesheet
  2. Re: listing data without blank rows
  3. Excel sheet scroll bar options
  4. need formula advice
  5. Do I need a macro or just a function?
  6. Change font/cell color by Formula
  7. Removing The N/A from showing in open fields
  8. Splitting firstName from Surname
  9. Excel Coding Error!
  10. lookup value and return result in column to left
  11. Conditional Formatting
  12. I want data to show in the cell only when the info is inserted
  13. Formula to look for value in a row depending on unknown value?
  14. How do I get a combo box to calculate percentages in Excel?
  15. retrieving old messages from this newsgroup
  16. Invalid Formula with the use of Indirect
  17. Transfer data relevent to date
  18. Transfer only information under todays date
  19. Fill in Date problem
  20. Formula not Return Required Answer Q
  21. Chop off parts of the statement
  22. Take fraction out of the figure
  23. inserting a space in a number
  24. Transferring contents and color of cell
  25. shortcut key to move to beginning of new row
  26. Dont include in sum if cell contains this value
  27. Oooh, I guarantee you are going to have fun with this one.
  28. Insert new row in 2 worksheets
  29. Auto Filter with Protected Worksheet
  30. copy value of cell from last entry in column
  31. I want any date 90 days or older from current date change color
  32. Simultaneously updating Charts in Multiple sheets
  33. Deriving mathematical equations
  34. can we convert "2 days 16 hrs" to " 64hrs" using excel functions
  35. merge 2 spreadsheets info to 1
  36. Change hrs&minutes into mins
  37. Add items to context menu
  38. Dialog box with worksheet information
  39. Zero Values in Charts
  40. Conditional Formatting Q
  41. Using the answer IF "true" in another formula?
  42. Auto calculate for date + days forward to yield new date
  43. If function
  44. sumproduct doesn't work
  45. referring entire page
  46. rolling average
  47. engineering functions
  48. How do I copy only values of cells when they are enterd?
  49. Inserting new rows
  50. how can I add a picture into protected worksheet?
  51. Could any one Explain this Formula
  52. How to create a 'dynamic' formula?
  53. FIFA World Cup 2006 Office Pool
  54. Lookup function not doing the job Help please
  55. VLOOKUP Returns Erroneous Value When Control Data is Variable
  56. Multi-Column Dynamic Named Range...Is there an easier way?
  57. Selectively Clearing cell contents
  58. can i prevent duplications in cells
  59. How to extract value from a different file?
  60. When I SaveAs, the hour glass does not go away, nothing happens
  61. if function
  62. if function
  63. Please Help...
  64. How do I create a tip calculator chart?
  65. calculation to ignore a 0 (zero) value
  66. how do i get excel on my loptop
  67. Uppercase
  68. Need a count
  69. sumif across multiple sheets
  70. Copyin text only...not borders or shading
  71. Data Query will not Refresh automatically
  72. same data from one cell copy to multiple sheets
  73. Average outage time?
  74. Cost times amount (if populated)
  75. Tricky comparing question
  76. how do i retrieve overwritten Excel file
  77. Excel Data not showing up in Query
  78. how many calculations?
  79. can you use the match formula to look for two different values?
  80. Fuction that gives number of days of a given month
  81. filtering
  82. Another "working with dates ?"
  83. Unable to break links
  84. Lookup and List Results
  85. Can I use the IF Function?
  86. Countif Problem
  87. INDIRECT Function
  88. Sumif between values
  89. thin # of samples by averaging
  90. problems with vlookup
  91. How do I convert a list of data into mailing labels?
  92. If Sum Countif Function
  93. Working with dates
  94. conditional sum formula
  95. Years of Service Calculation
  96. Semi Annual Counter
  97. Need help find automate way to cross reference two GAINT excel databases!!
  98. hyperlink to sheet in formula, can't save under new filename
  99. Please help with a 3d formula.
  100. List from a table
  101. Anyone actually get Case statement to work ... ?
  102. how do you add up alpha???
  103. how do i enter a formula in excel that will change a cell value
  104. Pivot Table Row ?Grouping? Question
  105. Count items when specific text and date criteria are met
  106. Can someone help with this complex formula?
  107. DFunction + Print Preview = Slowdown ???
  108. Criteria Range at two different places
  109. Spreadsheet formula question!
  110. How would i setup a breakdown method for my business?
  111. Comments box position
  112. automatically making a copy of a sheet
  113. automatically making a copy of a sheet
  114. Monthly NPV
  115. Macros?
  116. funtion to determine the fraction portion of a number?
  117. Edit and Array
  118. How to stop a general format cell
  119. WEEKDAY Function?
  120. Suggestion to add Auto Filter option for columns
  121. Counting text strings
  122. How do I create a formula where a cell is automatically shaded ?
  123. Excel formula to move certain fields
  124. transposing an array converts dates into numbers
  125. Calculations
  126. Excel Tips
  127. IF statement problem
  128. Pivot needs BOTH cur/*** totals w/out extra *** cols/repeat lines
  129. > but < subtotal (3,...) or countif
  130. passing excel certification
  131. How do I stop VLOOKUP from asking what spreadsheet to look in?
  132. Importing information from 2 workbooks into a 3rd one
  133. Letters and Number formulas
  134. Pivot Table Formatting
  135. Worksheet button to send as attachment
  136. how to create a sorted summary list of counted species
  137. Index not Reurn the correct Result
  138. Insert a imge to a single cell
  139. Formula for determining if two date columns fall within specific date range
  140. Template Wizard/Excel as database
  141. Multiple worksheets within a workbook
  142. How do I format a formula to recognize multiple comparison factors
  143. Help for a newbie... please
  144. Median Formula In Pivot Table
  145. Summing specific cells on two worksheets
  146. Average Non-Adjacent Cells in Budget Spreadsheet
  147. In Excel - how to delete new window created from window on tool ba
  148. Vlookup and hyperlinks
  149. how do I display number in thousands; i.e diplay 123,500 as 124?
  150. Function - counting based on criteria
  151. Msgbox experts please reply..
  152. how can you put a background in certain cells
  153. Data transfer from a template to a workbook
  154. If function
  155. Change fmt of a cell if number matches any in a range of cells?
  156. vlookup with linked cell references
  157. vlookup
  158. Combine Cells
  159. Want to change current prices in a column by a percentage
  160. number rounding
  161. If, then formula to capture data?
  162. write a "if" command. day of month + remainder
  163. Conditionsl Formatting
  164. What function/formula should I use?
  165. Issues copying excel charts to word documents - using Excel VBA
  166. What
  167. Is this possible with a macro?
  168. How do I stop cell borders dissappearing when pasting data?
  169. Combining IF OR and AND functions
  170. Lookup a value between two numbers
  171. workbook code
  172. how do i create form of yes/no answers for mass e-mail sending
  173. VLookUp function to return multiple rows
  174. time data as number
  175. Deleting Row Macro
  176. Circular:G4?
  177. Setting Conditional Formatting
  178. Counting unique values with criteria
  179. how do i get the equal sign on my formula bar in excel
  180. How to find duplicate data in two tables,then listing it?
  181. Disabling an 'on load' macro
  182. How to find duplicate data in two tables,then listing it?(Excel)
  183. Value depends on comination of 2 columns
  184. Expanding on a formula
  185. linking data to a form
  186. How to set a formula to convert the time zone
  187. How do I open worksheets in different screens, like Word??
  188. Referencing sheet1 from sheet2
  189. Validation Data
  190. vlookup function addressing
  191. AutoFilter list problem
  192. option buttons
  193. Check 2 different list get associated value from a column
  194. Summarizing data on one main sheet
  195. How to create menu for listed names?
  196. Automatic filtering and coping result to a seperate sheet
  197. What does the 0 in the formula 'Yr 3 Op'!G2,0 mean?
  198. Countif time is between two nominated times
  199. link with date to data worksheet
  200. Combining worksheets on a unique key column
  201. How do you add a blank line automatically after the Subtotal line
  202. Inoperative merge function
  203. Merge Rows depending on value of the first column
  204. Is there a macro or function to convert values to it written text
  205. Why doesn't this nested IF statement work?
  206. How do I sum totals from mulitple worksheets
  207. can someone explain function 'ara'?
  208. check boxes in the forms tool bar
  209. How can I subtotal a row that gives me =SUM(Q3:X3)
  210. excel storing previous cell values in memory
  211. Hiding sheet in a workbook
  212. Using FIND function to locate space between first and last name
  213. find nearest help
  214. Data alchemy
  215. "NOW" or "TODAY" date function
  216. VLookup?????
  217. How can you sort a worksheet which has embedded lists?
  218. IF function
  219. True or false
  220. SUM a named range
  221. Fractional Workday Function
  222. Drop down lists and vlookup? or Match?
  223. How do I combine data from several sheets into one main sheet?
  224. conditional formatting issue
  225. Need Excel Formula/Function to color cell interior
  226. Excel: Find repeated items and be able to delete quickly, option.
  227. Vlookup while pulling a cell color and comment
  228. Calculating Dates Using Different Values for NETWORKDAYS
  229. Multiple Vlookups & IF statments
  230. SumIf
  231. Excel
  232. lookup function
  233. How to trim spaces from entered text in cell using exisiting functions?
  234. school project ..please help
  235. EXcel Capture Data into one cell
  236. school project ..please help
  237. automatic calculations
  238. how do I compare two dates?
  239. Sort
  240. How do I exchange cell information; simply swap locations?
  241. How do I count cells that contain one of several specific numbers?
  242. lookup function
  243. Excel functions which support arrays (SHIFT-CNTRL-ENTER)?
  244. How do I format a cell so that I can only input a Y or an N
  245. bring up list
  246. LIST DATES IN MONTH ORDER
  247. Workbooks
  248. cond format
  249. how do i lookup the value of the next cell excluding the first lookedupresult
  250. Keeping formulas on running total and sorts