match cell

  1. J

    Matching, sum and return a value

    Hello! I have just started a new job and trying to get a handle on some new data and techniques, and I could use some help! I need to be able to match a project number in one excel sheet, to another, and return a sum of 2 cells relating to the project number to the original sheet. Basically...
  2. D

    Need list of cell #s to match Cell content

    I cannot figure out how to make a proper formula for this issue.... In Columns A-M, I have of various numbers and text. In Column N I have a list of unordered cell numbers (B20, E12, L60, etc.). I want to make a formula for column O that will display the data associated with each of those cell...
  3. E

    help plz this should be fast and easy for you!!!

    ok i have a sheet that looks like this and all i want it to do is this... <tbody> frist date of birth email jan. feb mar apr may jun jul aug sep oct nov dec eric 1/30/1986 eric86vabeach@yahoo.com *read note* bob 2/15/1990 bob@bob.com *read note </tbody> ok in cell...
  4. E

    How to match a cell value only if value is positive?

    Hello, What formula can I use to match B1 value with A1 only if A1 is positive? In other words: B1 equals A1 if A1>0 otherwise = 0 B2 equals A1 if A1<0 otherwise = 0 Thank you
  5. S

    help please with matching cells in a LOOP

    Hello Forum I am trying to loop through a doc. I want to test/match every item in the column against the first item, then loop and then test/match every item against the second item...and so on... and so on. I can successfully go through one column all the way to the end testing every item...
  6. M

    Need formula that links cell names with corresponding file name in folder

    I have an excel workbook which contains info on all credit notes we issue a month, the colunms are: Date, Credit Note No., Relating invoice, Amount, Reason and Account. I also have a folder (C:\Documents and Settings\My Documents\Credit Notes) which contains all the credit notes in pdf format...
  7. K

    showing values in increasing order

    I am using =INDEX($A$1:$R$1,MATCH(MIN(A7:R7),A7:R7,0)) to find the minumum number in the array. How do I display the value one position greater? I need to order the numbers and titles in increasing order. also any way to ignore the 0 vakues in the cell in the MIN function?
  8. M

    Search for range for sumif

    This is a complicated SUMIF that I am struggling with, I am trying to search for the term "TOTAL" in a worksheet (e.g. E14, E25, E36, E41 all have TOTAL), that will then give me the addresses of all these cells as a range for another formula within the same cell. Using this range, I then want to...
  9. O

    Excel VBA find, match and append worksheet values?

    On May 11th, 2008, 06:38 PM, MrExcelMVP "Fazza" provided an excellent code in response to a request by "gravy679" titled "Match and replace cell from another sheet": http://www.mrexcel.com/forum/showthread.php?t=318911 Sub test() Application.ScreenUpdating = False Dim cel As Range For...
  10. D

    Insert Cells / match columns

    Is there a way i can automatically insert cells to match the columns contents. below is what I'm try to achieve. hope you can help!... http://www.djt100.co.uk/before.html http://www.djt100.co.uk/after.html

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top