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. vlookup not accepting a reference
  2. Macro
  3. Stop formulas from changing on it own.
  4. Referencing Cell Colors - Help
  5. Display data list in Matrix
  6. Re: ERFC
  7. Re: integral calculus
  8. Re: Circular reference error - where ?
  9. Re: Try again: limit for # of rows to be split using text to column?
  10. index and match
  11. Rows and columns changing?
  12. Sum IF
  13. Re: data ranking
  14. Combo Boxes
  15. Function
  16. After the listbox gets chosen, how to populate another form
  17. Assigning Unique numbers in Excel XP
  18. counting instances
  19. VLOOKUP
  20. Insert Function in Excel 2002 (CopyOrigin field)
  21. section break
  22. Increase maximum capacity of text in cell
  23. Alternate Startup File Location
  24. Number formatting
  25. Count function
  26. Re: Variable Print Area
  27. Creating user defined function
  28. functions
  29. Time convertion function question
  30. Automatically sorting columns into worksheets
  31. VLOOKUP to determine...
  32. Re: Repeating data
  33. Worksheet Functions
  34. MEDIAN function
  35. Re: calculating easter
  36. Re: If/Then Statements
  37. Trying to contatenate multiple cells, with a "soft return" between each
  38. Formula to extract numbers from text
  39. Print Area vs Print to fit
  40. Using EDATE with arrays as arguments
  41. Row
  42. Excel How to update 100's of HTML Links instantly
  43. Re: Which function to use to count the records satisfying two criteria?
  44. COUNTIF Function
  45. Re: Unique entries in a filtered list
  46. Average for condition in different column
  47. Cumulative days calculation in a time series
  48. block text to date conversion on drag and drop - turn intellisense off?
  49. Custom date format
  50. Cannot change a part of a merged cell
  51. Excel 97
  52. When saving files I get a read only message
  53. FIFO
  54. Excel 97 read only
  55. Sheet name in a cell
  56. Re: Need Formular for Multiple Critera condition
  57. Increase No. of sheets
  58. calculating number of days
  59. Percentage of a Dollar Amount
  60. Convert Numbers to Text
  61. Excel/MSQuery/AccessTable Conundrum...!
  62. Set an undefined (variable) print area through a Macro
  63. setting up "find and delete row" macro?
  64. Extracting Emails
  65. Try to do a simple macro
  66. Copying cells horizontally (A,B,C,D) entered in a vertical path
  67. Convert data in Excel ! Help
  68. HAVE VLOOKUP RETURN 0 OR BLANK INSTEAD OF #N/a
  69. Vlookup - using a database as the table_array
  70. BE A WHIZ!!! Add specified text cells to equal "1" in last column
  71. how to convert the number into its text format
  72. Variable Print Area
  73. Conditional Formatting
  74. Offset formula to add range depending on date
  75. Sort Function in Excel
  76. Variable Print Area
  77. Copy a range
  78. Reverse Engineering of a Date to a Number
  79. freeze panes??
  80. formula for adding up total hours in a time sheet
  81. MROUND function
  82. Change cell reference for a linked formula
  83. COUNTIF formula
  84. Transfer Comments to a row of cells
  85. sort order
  86. % figure>then 66.6%=green text, % figure
  87. Invoicing
  88. Urgent help required - Excel Formula
  89. PAYROLL ISSUES
  90. Formula
  91. auto filter macro
  92. TABBING
  93. Excel Columns
  94. viewing works spreadsheet on excel 2000
  95. Named external cell reference
  96. something about function ACCRINT( )
  97. Creating a function to randomize a list of alphanumeric entries in an array
  98. Auto run macro on opening an Excel sheet
  99. Excel Formulas
  100. Minimun & Maximum Kilometers IF
  101. Re: Minimun & Maximum Kilometers IF
  102. Leading Zero's
  103. Formating One Cell based on If Another is Empty
  104. Re: set cell format in user function
  105. truncated text on a spreadsheet
  106. Cell Style/Formatting
  107. Re: How to change an UDF argument?
  108. Header
  109. Displaying Numbers Missing In A Sequence
  110. Mailing Labels
  111. Excel
  112. UPC-A Conundrum
  113. How to copy text between sheet?
  114. Multiple Aurguments in countif statement
  115. Formulas
  116. rank and percentrank error - please help!
  117. using functions after (using autofilter)
  118. easy formula not working
  119. Help
  120. ROUND to nearest 5
  121. Adding numbers in a column
  122. Adding rows in two dynamic columns
  123. Report manager & creating PDF files
  124. inputting formulas into a spreadhseet using other formulas and constants
  125. Generating unique sequential numbers in Excel
  126. Trend Line data point weight
  127. Multiple Criteria Formulas
  128. ACCRINT( )
  129. spread sheet formula
  130. Help
  131. Re: first derivative?
  132. Re: Help
  133. How to shift address info. from rows to columns?
  134. editing imported data
  135. Re: Question about Match and finding data
  136. help!!
  137. How to avoid duplicate invoice numbers?
  138. Find a value that has the largest difference compared to a given reference
  139. How to print formulas and their results on the same page?
  140. Printing changed pages
  141. Gridlines over watermarks
  142. Test for Number
  143. filename and path in footer
  144. Calculating multiple worksheet in one workbook
  145. Exporting Data By List
  146. VBA Help
  147. Macro
  148. Saving Custom Formats
  149. 24 hour time
  150. Look-Up ??
  151. CHIINV
  152. Countif and summing a different column
  153. Printing a 2 column, 2 page worksheet on one page
  154. importing tabs with leaders from Word into Excel, or creating variable length "dots" in Excel
  155. compound sum interest factor function?
  156. Converting time
  157. Buttons and Macros
  158. generating formula with a formula
  159. Workdays (continued)
  160. Naming cells for a project
  161. Getting rid of the "reviewing" toolbar
  162. Generating progress reports from gradebook
  163. Eliminate review ing toolbar default
  164. Re: Arbitrary Lookups with wildcard values
  165. List Boxes (Help!)
  166. removing the #N/A error
  167. Sumif based on rolling time period
  168. excel formulas
  169. IF(ISERROR(????)
  170. working between work sheets .pls support tnks
  171. Sperm cell counter using Excel
  172. Help with Rate function
  173. My own function cannot be exported.
  174. vlookup
  175. Extracting matching words within cells
  176. compare values for duplicates in columns
  177. User defined functions in vba ?
  178. Excel
  179. collect all different numbers from column and sort them
  180. Trying to create Database / Piviot tables
  181. Question on LOGIC ?? - PLEASE HELP
  182. Range across worksheets
  183. How to Make a Single Formula Apply to Every Page
  184. SUMIF and a criteria range
  185. Formatting Complex Number Functions
  186. Unique records
  187. fixed date and time stamp
  188. compare 2 sets of data
  189. Making the same change to multiple functions at once.
  190. I'd like my worksheet (and workbook if possible, too) always maximized when opened.
  191. Excel - feet, inches, fractions fo an inch
  192. Vlookup & functions
  193. relatively simple date formatting
  194. workday formula
  195. Extracting records that meet multiple criteria
  196. Recording Keystrokes
  197. Re: COUNTIF Formula hell
  198. sort sheet tabs
  199. CountIf on Upper/Lowercase
  200. automatic change color in a cell
  201. Re: Write Common Number into Blank Cell
  202. RATE function not working as I understand it
  203. VLOOKUP
  204. Formula VS Data Entry
  205. Incrementing all numbers in a column
  206. HELP with IF function
  207. Days remaining - holidays
  208. Look Up Function
  209. formatting numbers
  210. Is there a formula to tell me if one number is a multiple of another number?
  211. Replacing cell of a column with cell of other worksheet
  212. A quick question
  213. SUMIF mets text requirment a given number of cells to the left
  214. month()
  215. Re: Function to return current Row number
  216. Re: ship on Tuesday
  217. Count from left to right
  218. Skipping Zeros
  219. How to copy a worksheet from one workbook to another in VBA ?
  220. Counting???
  221. Minutes to Hours
  222. =IF???
  223. potable macros and Tool bar
  224. (Group) after file extension
  225. Find and delete macro
  226. Different Execl 'security' settings in different countries
  227. SUM
  228. Function to convert Number into words
  229. Dynamic range in formula
  230. Excel Formulas showing Nothing in Result Cell
  231. formulas for loan payments
  232. Date formats & Concatenate function
  233. Using Row values as input to Variables
  234. getting data from a set of closed files
  235. EXCEL CELL REFERENCES AS VARIABLES
  236. Days between 2 Dates
  237. Clearing Check Boxes automatically
  238. creating databases
  239. Column numbers back to letters
  240. Getpivotdata from SQL
  241. Excel formula's
  242. Tab Name or Sheet Name in a Cell
  243. Unique values of a range
  244. Reference to cell in previous worksheet
  245. Formulas
  246. cell's displaying 0.78125 instead of 6:45 PM
  247. Excel Formula (IF Function)
  248. RE: Filter Out data based on multiple criteria
  249. Data Ranges
  250. absolute refernces - range of cells
Google