I have few values in column H and I have its corresponding values in column I. e.g., remittance numbers of customer and followed by total for the particluar customer in column H and the value of each remittance number and the total are in column I, this is repeated for several customer in the same columns. I need to pick only the totals from coulmn H and its value in column I and put them in new columns like J and K. Please guide me how do i do this?
Row 1 is for headers, cols H and I as described.
In J2 enter =IF(COUNTIF(H$2:H2,H2)>1,"",H2)
In K2 enter =IF(ISERROR (SMALL(J:J,ROW()-1)), "", SMALL(J:J,ROW()-1))
In L2 enter =IF(K2="","",SUMIF(H:H,K2,I:I))
Copy the 3 formula down to bottom of list.
Archive for October, 2010
Need help with excel formulas and macros?
Sunday, October 31st, 2010Excel functions! apply a function to a whole column help plz?
Saturday, October 30th, 2010i want to apply a function to a whole column. in fact i want to apply the ‘sin’ function to a whole column instead of doing it one by one.is it possible to do so n if u know how explain clearly plz.
Basically you have two ways of doing that.
The first one is select the whole column, type the formula in the first cell and press CTRL + ENTER. Excel will fullfill all the selected cells. This will be easy to do but has a price and size and time to save your file.
The other way is use the list feature. To create a list, goto to Menu Data\List\Create a list option.
Press ok in the form and check your list\table. From now on, everytime you add a row, Excel will automatically copy down any formula that you’d typed in the rows above it. If it didn’t work in the first time, fill all the blank cells with formulas and check again.
Excel 2010 VBA – Shortcut To Select Range
Saturday, October 30th, 2010
Demonstrate how to use [ "insert cell range" ] instead of Range() in Excel VBAExcel 2010 Fundamentals – Part 3
Friday, October 29th, 2010
Learn the fundamentals of using Excel 2010. Topics include understanding the main Excel window, workbooks and worksheets, entering data into a table format on a worksheet, creating simple formulas and using basic functions, using absolute and relative references, operators, formatting data and changing worksheet structure, working with sheets, creating a simple chart or graph and sorting and filtering lists of data.
Duration : 0:7:2
Excel Finance Class 46: Bonds: Just A Set Of Cash Flows Discounted At Market Rate – Coupon or Zero
Friday, October 29th, 2010
Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htm
Learn how to think of a Bond as just a set of future cash flows that are discounted at a market rate. See examples of both a Coupon Bond and a Zero Coupon Bond. Learn About Yield To Market rates. See Math Formulas for Bond Valuation and PV function in Excel for both Coupon Bond and Zero Coupon Bond.
Duration : 0:27:38
Excel Finance Class 45: Interest Rates: Real, Nominal, Inflation and the Fisher Effect
Friday, October 29th, 2010
Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmMicrosoft Excel : How to Make a Formula in Excel
Friday, October 29th, 2010
In order to make a formula in Excel, type in an equal sign and go to the “FX” button in order to select “Sum.” Add several pieces of data together in Excel with help from an employee of an IT company in this free video on making a formula in Microsoft Excel.
Expert: Stefanie Northrop
Contact: www.cmitsolutions.com/pinellas/
Bio: Stefanie Northrop has over 14 years of knowledge and experience in the telecommunications/IT field.
Filmmaker: Christopher Rokosz
Duration : 0:1:15
Simple Sheet With formulas EXCEL
Friday, October 29th, 2010
in urduif I do really good in American High Schools, can i get into a good menntaskóla in Iceland when i move there?
Friday, October 29th, 2010Im in All AP classes, and i excel in a lot of things i do. will that translate over in the Icelandic school system. (not the AP classes, but the fact that i was a good student)
P.S. I speak enough Icelandic to communicate, but i have the vocabulary of a 7 year old, if i work hard, should that be a problem when it comes to getting into a school? My father keeps telling me that emerging myself into the language like that is the best way to learn it well. so i feel if i work hard, and am determined in learning it as i learn in school, i can have a good vocabulary. but do you think i can still get into a good Menntaskóla?
do you think that will stop me from getting into a good menntaskóla, because its pretty much like studying abroad.
im going to guess that menntaskola means school or college. Your father is indeed right, in order to become fluent or better at a language, you must first emerse yourself in the language. Im doing something similar as a matter of fact, except im trying to get into a japanese high school.
My advice to you is to start listening to icelandish music, study and quiz yourself everyday on previous stuff so that you wont forget them. Start watching iceland shows with subtitles then watch the same episode of the show again but without subtitles. Use flashcards when you study, and try to make sentences and or stories relelvant to the vocabulary youre trying to learn. I also suggest actually going to iceland and start conversations and stuff there. My father attended school in germany but he didnt know german at all, in a month or two, he becomes fluent in it because he had no choice but to understand, same for english. he went to work in america but only knew german and portuguese but in a summer’s time, he became fluent in english. He told me that there is no better teacher than experience.
It will carry over cause you need a good GPA if you do want to attend a school there. if its a transfer than everything from your current will be transferred, i think if its like a scholarship thing then i think so as well. youre gonna need alot of determination.
I am no expert in Excel formulas and after looking through as much plain language?
Thursday, October 28th, 2010I am no expert in Excel formulas and after looking through as much plain language Excel books I can find, I beseech your help.I will be pasting the time like 05:10 in A1 and I want result should be in minutes i.e. 310 in B1 cell what will be the formula for this could anyone assist me out
You don’t need a formula. In B1 enter =A1 but format the cell using this format [m]
