unknown

Hi All, having issues in getting a macro to work the way I want it to. my spread sheet has columns A-CO being used and rows 1-199. Row 1 is the column headings. I have a macro that sorts column K alphabetically whoever in doing so it has reversed it so instead of starting at "A****" in...

hi , i have an unknown rows so i want made a formula for it like A B C 1 2 3 9 7 3 8 2 22 1 39 2 i put this formula in C =VLOOKUP(1,CHOOSE({1,2},A:A,B:B),2,FALSE) Because i don't know how much rows in A and B , so i want check all of it whatever the number of it . thanks

Hi I need a formula that will count how many styles I am carrying per brand. The table array where I hold my data is shown below, cells A-D. Cell B states the name on the style, cell A is the size breakdown for that particular style. Cell C shows the brand attached to that style Cell D is...

I want to know if it is possible to retrieve data from excel sheets automatically without making any changes. This is the document link that i want the document to be like: [https://www.dropbox.com/s/a3pl7ets703ohxy/TOP%20Sheet%20.xls?dl=0] And, this is the link to the type of document that i...

I want to know if it is possible to retrieve data from excel sheets automatically without making any changes. For Ex: Lets say i have 100 workbooks of same type with titles Name, Location, Age, ID, Salary. Now, is there anyway that i can trigger excel to retrieve only the Name and Salary...

I've been given a university assignment where I am trying to predict corrosion rate based off moisture content for a buried pipe. The teacher wants a function based off corrosion rate (cr) (of which I have 130 values) and those 130 values corresponding moisture content (mc). These will also be a...

Hi, I am not even sure the type of formula that I need but I need to be able to copy something from one column into another column based on the value of a column... This probably makes no sense so I will explain with a picture.. Column A Column B Column C 100 Address1 200...

This is hopefully easier than I'm making it. What I'm trying to do is edit my bank statement before importing into Quicken via excel. I'm looking for what to put in the 'Find' window of the 'Find and Replace' dialogue box, which will allow me to delete "CHECKCARD xxxx". These x's represent...

hi everyone, i work with excel 2007 newest release and patches applied. i have a strange behaviour on some links in an excel workbook mapping some other sheets on a network drive that is accessible and working very fine... just to exclude that somebody is telling me that maybe there is a...