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. How to find a row in a sheet and compare the complete row /w origi
  2. How to seperate data in a cell which is split by a comma
  3. Highlighting a whole column
  4. made a new Myexcelcalendar06.xls
  5. where is spell check on excel 2007
  6. How do I keep cell color formats separate from text during A-Z sor
  7. sort data by criteria other than ascending or decending
  8. UK Excel User Conference - July 19-21
  9. Using a calander for date select in cell
  10. macro or worksheet function?
  11. Finding Cells
  12. Create button on worksheet to restore woksheets orignal values
  13. Problem writing formula
  14. Can I create an If Statement that will replace text
  15. How to set cell 00/1-20/000 to move to another cell
  16. I can't sort my miscrosoft excel worksheet anymore, what happened?
  17. Mail Merge from Excel file
  18. to make cell absolute
  19. Calculations not changing in cells
  20. Graph
  21. calculate days
  22. Excel - Changing value of a date by a number of calendar months
  23. Control Display of Drop Down List in Validation
  24. Sum IF
  25. lookup
  26. How to replace a text with another
  27. change letter to number add number
  28. change letter to number add number
  29. Calculate Ebay Insertion Fees
  30. need help
  31. cell sizes
  32. How do include Dates in a formula?
  33. Dynamic fill of columns
  34. Calculating a Percentage
  35. lookup across multiple columns
  36. how do I round hours worked to the next half hour with a 24hr shif
  37. String parsing with variable lenght strings
  38. SUMIF with multiple criteria, by columns
  39. how do i add text to Excel worksheet ?
  40. Can a workbook be locked against change to cells containing references to other files?
  41. Need a formula
  42. lookup help!
  43. Restore an Excel spreadsheet
  44. Excel kept on asking to save file every time I jump from one sheet to another!
  45. How do I compare lists in Excel?
  46. How do you truncate a text string?
  47. calculate a formula instead of returning text
  48. How to insert text in one column and populate numbers in another
  49. Round current time
  50. List Validation Improvement Suggestions
  51. convert lats and longs to decimals
  52. Function displays as text, doesn't return result or error
  53. Date Format
  54. Ranking - Excel 2003
  55. Excluding Zero's from Average (SumIF / CountIF)
  56. Comparing and copying information from one cell to another
  57. Formula to look up a column and paste results in another column
  58. =if with multiple choices
  59. Date Function
  60. Hide an entire tab.
  61. How to exclude data that has already been imported?
  62. If Vlookup returns error enter 0
  63. Conditional Formating a cell .. to Show Nothing .. if True
  64. Remove the "False" from Statement
  65. Conditional Formatting Formula
  66. Nested "if" for price list
  67. How can I get an expired date to automatically be highlighted?
  68. reverse mapping for LOOKUP table?
  69. Return Blank
  70. Printing Multiple Data Validation Lists
  71. Extract Certain Characters and Numbers
  72. Checking data range in Pivot
  73. copy data between sheets, but not the formula
  74. Copy/Paste Help Please
  75. Suppress duplicate data
  76. Data Table Input Limits
  77. copy 40 tabs into 1 tab automatcially??
  78. Printing
  79. How to feed dynamic information to a drop down List (Validation Feature)?
  80. Average a part of a on going column
  81. Replacing missing values?
  82. how to extract input data?
  83. Creating a formula that will SUM with 2 Variables
  84. Need to look up value in another Sheet based on criteria in first sheet.
  85. DropDown Menu
  86. solving a formula
  87. rolling sheet references
  88. Lookup 2 directions
  89. Data tracking and auto sequential numbering
  90. How do I create a conditional formula that hides a complete row o.
  91. Average time for a race in minutes seconds & tenths
  92. Target directory & Path
  93. Large Function returning top values
  94. Date Calc in hours
  95. Macro to help oepn the file without prompting fopr passwords
  96. Macro to help oepn the file without prompting fopr passwords
  97. how do I set up if an answer is No then following row is hidden
  98. Links error if referenced file not opened
  99. Re: Data Ranges
  100. =networkdays formula was working, but not in upgrade to 2003
  101. Re: How do I do this, can it be done?
  102. Data Entry Using Pulldown
  103. How do I do multiple IF statemnets in one cell in Excel?
  104. Min Max Editing
  105. Counting the occurences
  106. ADD Macro - xlup plus xlto right
  107. formula for lenght of employment based on hire date
  108. rowwise total!
  109. Convert WeekNum to Sunday's date
  110. Formula for top n
  111. How do you link multiple cells in a worksheet?
  112. Re: Is it possible to automatically change color of cell by keying off the date?
  113. Color Code Rows
  114. Create folders in Window Explorer from tab or csv files export
  115. LIst Problem
  116. Matching Combinations
  117. how to get a total to add up a range
  118. Re: intersections of rows and colums in calculations
  119. How can I get TreePlan for excell?
  120. individually time stamp a row when a change is made to that row
  121. Re: intersections of rows and colums in calculations
  122. XIRR & -ve answers
  123. Excel - need an serial # to update everytime sheet is printed.
  124. Run Macro from a Cell
  125. How do I format spreadsheet w/o changing font size?
  126. Conditional Format - 2 lists of names to find matching cells.
  127. Simple? Formula for "for the week starting Monday May Xxth"
  128. Nested if in Array
  129. automatic address and phone cell entry
  130. How do I "lock" a graphic to a particular cell in Excel?
  131. Combine many exel files to one
  132. VLOOKUP in large Data sets of more than 16384 rows
  133. Text To Column
  134. Update Links
  135. conditional fomatting
  136. How can I create an AutoFormat row color change for a value in a c
  137. Calculating time between values (tricky Problem)
  138. How to creat summery file form many xl files?
  139. how do i make one part of my formula bold and the other normal?
  140. HELP: text keeps on displaying ##############
  141. Can i print non-contiguous areas on one page
  142. Matrix info
  143. Option Button
  144. sumif statements
  145. Delete empty rows from print in Excel
  146. SUM ERROR
  147. conditional formatting in excel
  148. crazy discount !!
  149. Hyperlinks within worksheets
  150. Who can I make a Cumulative calculation in Excel sheet?
  151. Averaging data
  152. xirr prorated?
  153. Formula Help
  154. add time greater than 9999:56
  155. How do I create a formula by percentage within a formula?
  156. Vlookup and SUM
  157. Making Cell Blank
  158. I want to count *'s that i have put in my sheet ?
  159. show fridays
  160. Vlookup in pivot tables
  161. worksheets xlSheetVeryHidden and show them once password-app
  162. conditional formatting with dates
  163. Prohibit entry of special characters
  164. Date and Time
  165. When I insert rows in Excel the pagination gives me unwanted page.
  166. replace blanks using formula
  167. formula in one cell or another
  168. how can i make dual label cells?
  169. copying part of a cell's contents (formatted as dd:hh:mm)
  170. Font selection within formula
  171. validation rule - force text entries to appear as Proper
  172. is number between values
  173. 'IF' FORMULA TO CAPTURE CERTAIN CELL VALUES
  174. Lookup and conditional formating
  175. RE: is number between values
  176. how to consolidate data in different excel sheets
  177. RE: how to consolidate data in different excel sheets
  178. create a list box in one cell of state abbreviations
  179. Help with CountIf < and > time formula please
  180. HTH
  181. Verify spelling in a vlookup formula
  182. how do I get a spreedsheet to print an 8x11 size
  183. sumif or count between zero and 3
  184. VLOOKUP USING 2 LOOK UP VALUES
  185. RE: 'IF' FORMULA TO CAPTURE CERTAIN CELL VALUES
  186. RE: Font selection within formula
  187. using the countif function
  188. Scroll bars: how can they be rotated?
  189. holding a value after first calcuation
  190. How do I set up a formula to count only unique items in a column?
  191. Amortization template for uneven monthly payments
  192. RE: How do I set up a formula to count only unique items in a column?
  193. Excel formulas
  194. RE: formula in one cell or another
  195. RE: formula in one cell or another
  196. How do I differentiate between duplicate ranks?
  197. RE: VLOOKUP USING 2 LOOK UP VALUES
  198. how to create refrence using first and last words of any supplier
  199. How can you get a macro to work in transfer data from AS/400?
  200. RE: Excel formulas
  201. RE: how to create refrence using first and last words of any supplier
  202. maximum entries
  203. Validation rule - custom 5 digits w/ leading zeroes
  204. RE: HTH
  205. repeat an entry on spread sheet
  206. RE: Date and Time
  207. How do I set up a euchre rotation schedule
  208. Tabbing through Unlocked cells
  209. Insert Row & Copy Formula
  210. countif
  211. Auto Numbering
  212. an excel formula for specific conditions
  213. sort data rows "greater than or equal" criteria in another cell
  214. CALCULATING A FORMULA TO USE A SPECIFIC CELL'S VALUES
  215. RE: an excel formula for specific conditions
  216. dechex
  217. Getting a case sensitive match?
  218. RE: an excel formula for specific conditions
  219. Returning contents of a cell
  220. Sorting Formulas with "Empty" Results
  221. RE: Auto Numbering
  222. Problem using IF function for a gradebook
  223. RE: using the countif function
  224. RE: Problem using IF function for a gradebook
  225. RE: Font selection within formula
  226. AND array
  227. RE: VLOOKUP USING 2 LOOK UP VALUES
  228. Summing a range with conditions
  229. lookingup a value in a table
  230. Conditional If statement
  231. RE: 'IF' FORMULA TO CAPTURE CERTAIN CELL VALUES
  232. Sum up a particlar cell in multiple Excel worksheets within same b
  233. RE: sumif or count between zero and 3
  234. how can i get a cell to flash or blink
  235. Conditional Formating
  236. RE: VLOOKUP USING 2 LOOK UP VALUES
  237. Combine 2 spreadsheets w/1 common column of data, text and number
  238. RE: countif
  239. RE: how to consolidate data in different excel sheets
  240. RE: repeat an entry on spread sheet
  241. RE: Help with CountIf < and > time formula please
  242. RE: how do I get a spreedsheet to print an 8x11 size
  243. Detecting patters in data
  244. RE: is number between values
  245. RE: Summing a range with conditions
  246. Conditional data
  247. Extracting using seperators
  248. multiply time and currency
  249. decimal to 16 bits binary conversion in Excel?
  250. nested if statment - needs if(isna