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. grouping and give colours
  2. use range name in formula
  3. Complile Error with Date
  4. Mulitplie workbooks - known duplicate records - need to consolidat
  5. Convert Numbers to Text
  6. How do I move information between worksheets?
  7. User Group Meeting Ideas
  8. Lookup Hi / Lo
  9. Dynamic range for Table_array in a VLOOKUP.
  10. 3D Arrays
  11. If statement w/ rounding but not all numbers
  12. Is there a function to consolidate multiple records into one recor
  13. compare two groups of data
  14. Change formula to Indirect
  15. between - function?
  16. ROUNDUP copy/paste and fill handle not working
  17. Drop down to diplay info from another sheet
  18. need a roster that 3 kids can work to day by day?
  19. HELPPPP!!!!!
  20. Please help!
  21. Sorting columns
  22. sequential numbering of copies printed
  23. Distributing values from rows to columns for Access import
  24. how can I make a form number change everytime the form is opened
  25. Using scientific notation in TEXT() function
  26. populating multiple cells
  27. INT Function
  28. sumproduct?
  29. Lookup Functions
  30. outline & groups
  31. .csv file - excel 2003
  32. Return a cell value based on specific combinations of cells in an array
  33. calculate using rolling calendar
  34. Countif function for instances of text string contained
  35. RE: Countif function for instances of text string contained
  36. How do I "show pages" in pivot tables in Excel 2002
  37. About User Defined Functions
  38. How do I use a range of numbers in an if statement?
  39. "Cannot empty Clipboard"
  40. cannot open files
  41. How do I keep the zeros in front of numbers when i split a cell
  42. Bonuses and Penalties in Grade Books
  43. Help, how to find a range of data?
  44. Scrolling Cells
  45. LOOKUP question
  46. Index/Match question Need help!
  47. Countif a small or capital letter
  48. Wroking with rounded or trunc calculation
  49. Date entry gone haywire in Excel!
  50. How do I search for specific text and sum the cell to the right?
  51. Excel should be able to map which cells reference each other.
  52. another sumproduct question
  53. Calculate difference (mins) between 2 Times
  54. Defined Named cells lined to a Function Procedure
  55. Multiple protections
  56. return a range of cells from a vertical lookup
  57. Converting decimals into hh:mm
  58. Unique Value without using FILTER
  59. How to select cells (located in a column) for formulas in a row automatically?
  60. Calculating the maximum value in a range of cells in a closed work
  61. Formula chooser?
  62. Excel - matching data
  63. Limit on number of conditions?
  64. Can I search the whole workbook and not just a sheet?
  65. Schedule/Date Calculation
  66. Drop data from workbook after specified time
  67. Excel expression {=SUm(if(istext(c8:k8),1,0))}
  68. How do I change numbers from positive to negitive
  69. HELP!!
  70. Making Array Formula, please assist!
  71. assign value to text
  72. need to calculate time multiplied
  73. In Excel allow freeze pane in any column plus any row
  74. Blank field formatted as date
  75. How can I use a circular function to add 4 to a column of cells?
  76. HOW DO I EXTRACT ALL CHARACTERS AFTER 5 CHARACTERS ON LEFT
  77. How do I concactinate two columns of digits?
  78. An icon on the forms toolbar is unavailable?
  79. Cell Fomula
  80. Pivot Sort ???
  81. reformat columns to rows?
  82. If correct, add 1
  83. Excel Math Wizards
  84. Easier Way?
  85. Can I email a single sheet in a workbook?
  86. Removing a FIXED Function
  87. Using Auto Filter
  88. Text size in validation drop-down list box
  89. Can I group data on different rows together and then sort the grou
  90. Hour() function
  91. MEDIAN() as array function?
  92. Hide (limit viewers) to column(s) on a protected worksheet.
  93. If(and spread sheet syntax
  94. HOW DO I MOVE ONE ROW TO ANOTHER PAGE USING A FORMULA.
  95. function
  96. Formula to capture data on a date and preserve it
  97. selecting data from a list box
  98. look up formula
  99. Excel macro to multiply by same value
  100. Simple Question
  101. Formula Help
  102. How do I create a worksheet function for polynomial data fit
  103. Excel function same description but different result
  104. PrintDate "as in MS Word"
  105. Filtering numbers????
  106. VB Script in Ecell
  107. Counting the number of formulas on a sheet
  108. Adjusting prizes to cater for ties
  109. Sum function which ignores hidden rows
  110. how can I extend the condictional format to nine conditions?
  111. Crystal & Excel
  112. How to replace column letter in refferences with a function using the old column letter?
  113. Get Vlookup to look at multiple Rows for the answer
  114. Formula for "highlighting" data
  115. Date-orientated update of cells in different spreadsheets
  116. Negative Number put in a certain column in a different sheet.
  117. Does Ctrl + F works in protected file with formulas?
  118. autosum on the taskbar?
  119. How to make LOOKUP give zero if it can't find the lookup_value?
  120. finding values and displaying adjacent values
  121. Check for duplicates in excel file
  122. How do I share my auto correct file with other users?
  123. IF function and speech recognition
  124. how do I convert a number to number of years, months and days
  125. Paste Special - All but formulas
  126. preserving format in a formula
  127. Create Excel Log automatically from Template
  128. Countif ?
  129. Transpose Color Formatting to Seperate Worksheet
  130. DUPLICATE VALUES
  131. Multiple Column AutoFiltering
  132. Multiple Columns & VLookup??
  133. Compounding payments
  134. =IF
  135. INDIRECT.EXT problem with missing worksheets
  136. Multiply one value by many factors
  137. Link in the same w/s is pulling a different number.
  138. identify duplicate enteries
  139. Convert Formula Result
  140. how can i stop excel from automatically creating copies of workbo.
  141. Need a formula that finds the last used cell in a range
  142. Percentage of amounts and profits of individual sales
  143. IF function....testing against values in multiple cells
  144. how do i automatically change the day and date
  145. Integrations/differentiations in Excel?
  146. Combine multiple cells into one cell range.
  147. Format cell window size
  148. How do I NOT round off in a formula
  149. How do you count (not sum) cells containing special formatting?
  150. Sorting not getting what I want
  151. sumif with or
  152. how to delete duplicated content from 2 cells
  153. Can a macro erase it's self after a set criteria?
  154. SUMIF
  155. Help .... sum function
  156. Using MAX with OFFSET and MATCH
  157. Match Each Numeric occurrence and Return Individual Rows of Data
  158. IF (table)
  159. Can Solver solve this?
  160. Excel and ranges
  161. Relative Ranges in excel macro
  162. Value_If_true - Question
  163. formula that gives me a random number less than other number
  164. Trying to plot two lines onto a single graph in excel
  165. How do i lengthen an existing VLOOKUP table array?
  166. Compound array question - what am I doing wrong?
  167. Days Within Months
  168. combining countif with AND function
  169. vlookup returning multiple values
  170. Workbook Sharing
  171. get all row nos
  172. How to change column letters to correct ones in many formulas automatically?
  173. Asking for user input if there is no data for the function
  174. Two columns
  175. How to replace a function with its result or resulting reference in a formula?
  176. Date Count
  177. Subtotal function for hidden row
  178. VLOOKUP not returning correct value
  179. How to replace a function with its resulting reference in a formula?
  180. How do I centre rows top to bottom?
  181. highlight/unhighlight (or color/uncolor) cells containing a specific character
  182. How do I set up a conditional function in Excel
  183. Combined VLOOKUP AND BETWEEN FUNCTION
  184. Compare Two Data Files
  185. Median ignoring Zero Values
  186. copy and paste hidden rows
  187. vlookup gives me a #N/A
  188. Updating different worksheet with value on current worksheet
  189. How to see columns from which values were not returned by HLOOKUP functions?
  190. Using a UNC
  191. Time conversion
  192. In excel I wish to copy the value from a cell.
  193. how to count records in a sorted list
  194. Loading Column Data with blank Rows into Data Validation Box
  195. what is the max number of factors in Linest function
  196. Excel Formula
  197. Cell Content Greater than 24 Characters.
  198. Return Sundays date of current week
  199. How do I link to other worksheets
  200. Limit the number of characters that a cell contains
  201. EXCEL Sum column based on time range in different column?
  202. IF formula problem
  203. Trouble copying worksheets between books - is there size limit?
  204. Rank
  205. How do I add increment a text field value?
  206. Missing Sheet Tabs
  207. Color Change
  208. Is there such worksheet functions...
  209. Excel help
  210. remove a year from date value in mulitple cells
  211. SumIf in Visible Cell Range
  212. Spliting the contents of a cell to other cells
  213. linking file equation...
  214. SUMIF with rows and columns
  215. HOW DO MATCH AND ELIMINATE AMOUNTS IN TWO COLUMNS IN EXCEL
  216. Linking worksheets
  217. Bowling Game
  218. Automating hyperlink creation
  219. Add "left align across selection" cell formatting
  220. compute insulin doseage with carb consumed & BS readings
  221. Removing errant apostrophes
  222. Excel formula
  223. UDF Raising an error
  224. How do I count the # of unique occurences of a text in a column?
  225. Please help, i need a fomula
  226. Enable macros?
  227. Shades of Gray
  228. show page breaks
  229. remove " $ " from formula
  230. Algebra
  231. RE: number formats after concatenate
  232. auto working week-ending date for timesheet
  233. Search multiple worksheets
  234. referencing Excel sheet name in cell
  235. How to change cell colour, X no days from inserted date in Excel?
  236. formula help
  237. function help
  238. RE: number formats after concatenate
  239. RE: How do I find value of "x" (col A) when I know "f(x)" (B)?
  240. RE: If condition is true return sumproduct of two arrays
  241. Name a Range - Macro
  242. number formats after concatenate
  243. What is the formula to reference a cell in a different worksheet?
  244. If condition is true return sumproduct of two arrays
  245. How do I find value of "x" (col A) when I know "f(x)" (B)?
  246. form that calls hidden worksheets
  247. NEED A COST SHEET TO TRACK TIME AND BUDGET -CONTRACTOR
  248. SKIPPING A COLUMN
  249. Make invoice take items off stocklist in excel workbook
  250. Countif array formula
Google