Functions
in [Excel]
|
copy paste value I have a colum of vlookup numeric data and want to add it up, but each cell may not return a value depending on how many items are needed. I belive I will need to add a colum in and grab the numeric data that is returned and then use a formula to do a copy paste value and if no value equal zero. I am not sure ... 22 Apr 2010 11:23
Columns labeled with numbers not letters Thank you very much for posting this! I am still not sure how I flipped it, as I know I was not in that screen before, but at least it is fixed now! "T. Valko" wrote: In Excel 2007: Office button>Excel Options>Formulas>Working with formulas>uncheck R1C1 reference style>OK -- Biff M... 22 Apr 2010 09:18
I want to compare two coloumn particular text, then count total I would like to compare two different coloumn particular text then count total example: A1= "IN" , D1= "RES" A2= "FI" , D2= "SBK" A3= "IN", D3="RES" i would like to compare above coloumn i.e. how many "in" = RES, how many "FI"= sbk please help me ... 22 Apr 2010 09:18
More than 7 If Functions Example is IF(A2="Bongaigaon", B2*40, .. i want to use if Command in which 19 times If Function to be used for Example of the Function is =IF(A2="Bongaigaon", B2*40, IF(A2="Dhemaji", B2*100, IF(A2="Dhubri", B2*50, IF(A2="Dibrugarh", B2*65, IF(A2="Golaghat", B2*50, IF(A2="Guwahati", B2*20, IF(A2="hojai", B2*50, IF(A2="Jorhat", B2*60, If(A2="Kharupeti... 22 Apr 2010 08:16
Reference different lines in the same cell Hi all, I have an excel sheet were in some cells there are multiple lines created by pressing "Alt + Enter". Is it possible to reference each individual line within these cells separately in a formula? Thanks a lot ... 22 Apr 2010 07:13
How do I search for the second largest value in the array? How do I search for the second (or third and so on) largest value in the array either in column or row? ... 22 Apr 2010 05:09
Conditional format will not work without $ (removed to allow c Great, thanks Duke, that worked "Duke Carey" wrote: If the values you want to compare ARE ALWAYS in D134 and E134, then you need the $ signs. Those tell Excel to anchor the comparison to those cells. If you are trying to use different compariosn values on each row, so that, fr instance, the D134... 22 Apr 2010 04:07
combine multiple spreadsheets into one workbook i have approx 800 individual excel files. i want to put them all into one excel workbook - creating one workbook with 800 worksheet tabs. Is this possible without opening them all and dragging them into the one workbook one at a time? ... 22 Apr 2010 08:16
Excel 2003 make 1 date cell automatically change another date Some of the equipment needs reinspecting every 3 months some every 6 months and others can be from 12 months to 4 years is there a formula that I can place in the reinspection date column so that it counteracts with the set amount of days for each month without been set to a rounded number like 90 days ( eg. Au... 22 Apr 2010 04:07
Installing service reminder popup windows in excel I am using Excel 2003 to create a complete equipment register which I have divided up into quite a number of sheets within the one Excel document. Within each sheet there is a date column for recertification for this equipment. The question I have is, is there some way to have a popup screen when you open up t... 22 Apr 2010 01:01 |