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. AutoCorrect
  2. Formula Help?
  3. offset function
  4. intersection of row and column
  5. Macro Button
  6. Lookup function
  7. I want to check for a text value, not numerical
  8. how i can aarange names in alphabetical odders
  9. vlookup problem
  10. pounds multiplied by hours
  11. Replacing #N/A with a '0' (zero)
  12. Using Symbols in Drop Down Lists
  13. Creating fixture lists
  14. Converting Letter Grades to Numeric
  15. conditional coloring
  16. Can I retain a formula in the cell pasted to?
  17. How can I format a "cell" so it come out as " /64"? Example 10/64.
  18. MCONCAT only Visible Cells
  19. Can a conditional cell formula reference data selection in a comb.
  20. Max Date and Item - How to get in one sheet ?
  21. formula to determine if cell is merged?
  22. Excel should have an unlimited number of columns available.
  23. How to caculated total due on taxes
  24. How do I link one TEXT cell to others in a worksheet and workbook.
  25. how do i convert payroll calculator in U K format
  26. SumIf or SumProduct or If statements
  27. Concantenate Text with numbers with fixed form
  28. lookup
  29. Adding Data Using Multiple Worksheets to Total into a Grand Total
  30. Last text value in a column
  31. Relocating info using Data Validation
  32. formula to alert if expiring within 40 days
  33. A COUNTIF function Challenge
  34. Total a Combination of Numbers
  35. Can you have mulitple drop boxes on 1 worksheet?
  36. How do I do a file compare of one excel spreadsheet to another?
  37. Automatic Tabbing?
  38. IF statement
  39. convert date of birth to current age
  40. Combine query to count products with similar names
  41. Text Function
  42. How to password protect a cell but still be able to sort ?
  43. Is there a way to go to next empty cell in a formula
  44. Three levels of protection in one worksheet
  45. Re: #NAME?
  46. MS Excel Question
  47. Countif using format criteria....not number criteria?
  48. How do I use a function to return the address of a cell?
  49. Countif using format criteria not number criteria?
  50. decimal place and merging to word doc.
  51. does the =COUNTIF have to be a range?
  52. ??
  53. Function needed please
  54. Named SUM Formula with relative refernce(s)
  55. How do I create a new symbol to enter as a character?
  56. array formular
  57. Replacing #N/A with a '0' (zero)
  58. DIFFERENT CURRENCY FORMATS IN FORMULA
  59. Excel Formula's
  60. MACRO LEARNING
  61. increase my worksheet by 1.04.
  62. User Defined Functions
  63. return groups of components
  64. Counting occurences of a specific day between two dates
  65. It's better to have it and not need it then...
  66. Excel should allow sorting and filtering based on cell color.
  67. reduce # of charachters in same cell
  68. Vlookup and Hlookup
  69. Help to Modify these guys
  70. NEED 30 -31 days for data for each month.
  71. Run-time Error in Excel?
  72. column headings
  73. NUMBER OF COMMANDS
  74. place empty cell with zero
  75. Date Conversion
  76. set a yearly alert for information in cells
  77. Find and REPLACE within a selection, or column- not entire sheet/.
  78. More than 7 IF statements in one arguement
  79. The UNPROTECT option
  80. HOW DO I HIDE THE ABC ( TOP ROW ) AND MAKE MY HEADDINGS PERMANENT
  81. Concatenate columns, separated by double quotes
  82. time/distance calculation
  83. How do I generate random numbers using dates in excel?
  84. sum if
  85. Excel 2003 versus 2002 seem incompatible related to the EDATE fun.
  86. bar graphs
  87. Excel 2003 Referencing multiple workbooks via single variable
  88. Multiple selections from a drop down list in Excel...
  89. Need help with Formula
  90. How can I merge multiple sheets from different Excel files workbo.
  91. Choices made available dependent on another selection?
  92. if sum
  93. Function Help!
  94. Build in Code
  95. Organizing Data
  96. How can I make a checkbox create a value?
  97. find smallest number not equal to 0
  98. Calculating net profit
  99. Products
  100. Nested IF - Work Around for 7 nest Max
  101. INDIRECT Function and Autofill
  102. Change caption on a macro button
  103. Isolate rows based on highlight (Excel 2003)
  104. Using Excel converts number to english text
  105. Desperate NEED!!!!
  106. condition statements
  107. Alert for errors on a worksheet
  108. Need to find the 1st two characters of the 1st two words
  109. Record hh:mm:ss on click of cell
  110. function does not recalculate sum
  111. function does not work properly
  112. Can someone please help?
  113. Using Excel convets number to english text
  114. remove blank lines from an entire spreadsheet
  115. Re: No Drop Down Tab showing
  116. command button properties
  117. Editing text after concatenate
  118. How do I conditionally insert an image (.bmp file)?
  119. ADDITIONAL FIGURES IN COLUMN DON'T ADD TO TOTAL IN EXCEL
  120. Calculates Qty Received
  121. Can I add blank space instead of 'FALSE' in VLookup?
  122. Date & time assistance
  123. Dates to number in edit line
  124. prehistoric time series
  125. Re: Function Mal-Functioning
  126. CONVERTING NUMBER TO TEXT
  127. Excel formula
  128. Reverse Concatenate
  129. count if function with if statements
  130. exel spread sheets
  131. Automated Hyperlinking
  132. what does "," mean in an excel formula
  133. I cannot type in my Excel program. The Font and size area is shad.
  134. need function help
  135. Font and size are in Excel has gone shaded. Will not let me type.
  136. Divde by zero Error
  137. CF for over/under mean unit
  138. Formatting issue
  139. Replacing MCONCAT with CONCAT_RANGE (in a complicated formula)
  140. Formula that will allow you to add one to cell's value by clickin.
  141. Unique Entries
  142. How do I automatically increment worksheet number when pasting a .
  143. Need help Returning the cell addy/index of the first non-zero number
  144. Unsure about which functions to use
  145. What does "," mean in a formula?
  146. Array brackets
  147. Counting issues
  148. Re: Add two cell values, retain it, and add another value
  149. comare and copy
  150. how do i extend the series of a portion of a formula?
  151. Converting sum of time
  152. text to formula
  153. INDIRECT syntax?
  154. Selecting ALL names when using Insert/Names/Apply
  155. How do I create a Calendar Drop Down menu for a Validation cell
  156. How do I keep from repeating total on spreadsheet in excel.
  157. Calculation based on a condition
  158. i am unable to link between two files in Excel, why?
  159. COUNTIF Function
  160. How do I compare two lists of numbers?
  161. autofilter
  162. In Excel how do I put variables in links to other workbooks?
  163. How can I do a "Save As" on a protected excel worksheet
  164. Putting numbers in excel without it changing into a formula?
  165. Need to have multiple worksheets use a single worksheet
  166. function to check numeric value
  167. Can you combined the SUMIF and SUBTOTAL functions in a formula?
  168. Combining SUMIF and SUBTOTAL functions
  169. Excel database - merge to Word
  170. Pivot ranges and INDIRECT
  171. How to lookup a value from a ramge of data. Eg Column C Row D?
  172. How can I protect cells in Excel 2000?
  173. How can I sort this:
  174. Formula for button name
  175. How to get difference in hours
  176. Divide by Zero
  177. Excel2000 A working formula has {braces} which disappear. Why?
  178. Replacing MCONCAT with CONCAT_RANGE (UDF)
  179. Stripping out imbedded spaces in a cell/row
  180. Same cell added to master summary sheet
  181. Replace a ; with a , and a space
  182. Autofilter hangup
  183. Cells not updating
  184. Help with OR statement
  185. Display Format with Text & Formula
  186. Count If Function
  187. Change the font case of all cells in the worksheet to uppercase?
  188. Inserting/Deleting Spaces
  189. countif question
  190. IF function
  191. Insert rows, keep a formula?
  192. Allow (validation) except
  193. Sorting a portion of a range
  194. Default to beginning of month
  195. .pdf hyperlink
  196. Sum of dates
  197. How to remove duplicates from a list and copy new list to new colu
  198. Copy cells into range of cells until cell change
  199. SumIf Help??
  200. RE: SUMIF or SUMNPRODUCT Help
  201. Sum only last X cells
  202. Sumif function with two criteria from different columns
  203. Populate 120 cell column with successive months entering only firs
  204. auto change number entries
  205. Is there a way to import a pdf file in to Excel
  206. Date Defaulting
  207. Re: I would like to apply the same calculation to an entire row
  208. need help with a simple time formula
  209. Accumulation
  210. IF statement
  211. VLOOKUP - results do not appear in cell
  212. Comparison / Check Off between 2 excel sheets. HELP NEEDED!
  213. Help with using a cell in function
  214. How can I get automatic row height for merged cells with text wra.
  215. Time Calculations
  216. Need to switch 2 columns with each other...please help
  217. HELP SVP- EIYHER OR ENTRY OR LOOKUP
  218. divide by 0
  219. Changing the Row_index_num via HLOOKUP
  220. Last weekend of month
  221. selecting days of week using a formula in spreadsheets
  222. entering rates five % higher
  223. Function to set borders of cell
  224. Is the a better way than LOOKUP?
  225. VLOOKUP Help
  226. Golfsheet function
  227. SUMIF with 2 criterias
  228. I want to use the MATCH function with the AVERAGE function but I .
  229. Quasi Transpose / Stacking Columns
  230. VLOOKUP with 2 Criterias
  231. Not summing a columns?
  232. Want VLookup to Return the row above
  233. Why is coditional formatting not accessable?
  234. Removing house numbers from addresses
  235. math
  236. Please help me.
  237. Comparison / Check Off between 2 excel sheets. HELP NEEDED!
  238. Excel If function alternative
  239. Adding numbers in a column that have 3 decimal places
  240. Why does the macro not work?
  241. The reference changes when I insert a row?!?! Help
  242. Date & < sign I want to Conc.
  243. Concatenate text and numbers?
  244. Apply to next X cells to the right...
  245. I need a daily sales sheet to pull from monthly figures sheet
  246. IF fuction and format ...
  247. Cell to Show "Continued" only if > Page 1
  248. Number formatting
  249. selecting non adjacent cells
  250. Incorporating cell content into a message in a formula
Google