exact

  1. J

    GetCellValue - Sum instead

    Hello, How would I alter the following code so that I could get the sum of F12:H12, rather than just the exact cell H12? destcell1.Offset(r, 0).Value = GetCellValue(folderPath & fileName, "Forecast", "H12") Many thanks.
  2. G

    Granular Control

    When copying data in excel. Press Shift-PageDown. Can you control the exact number of rows it covers down? Thanks
  3. J

    match data by keyword

    hi all :) i need a formula to match data in 2 columns that is not necessarily exact - therefore i'm thinking if i can identify field that have a common field i can see if the data within an index is a match. for example in the if i had a formula for the first cell (software warehouse) it would...
  4. B

    IF Formula replacement instead of using EXACT

    I have an IF formula I've been using that uses EXACT function in it, so anytime something was in CAPS and it matched a cell it would come back with a 2. If it matched but wasn't caps it would be 1. Then those numbers would be tallied. I wanted to see if maybe there was another array I could...
  5. A

    Sumproduct

    Hello Guys, is there a way to use this formula with closed workbook. countif(workbookname!A:A;"FB*") sumproduct(--(workbookname!A:A="FB*")) this work with exact text not with * thanks and regards
  6. L

    Exact compare rows from different sheets and different row ranges?

    Hello! Me again:) Never stop asking questions:) I need formula to EXACT compare rows from different sheets and different row ranges? I have another formula wich serve me when i need compare two identycal ranges(tables): {=AND(EXACT(A1:D1,G1:J1))} double click to copy down, wich is great...
  7. M

    Case Sensitive Vlookup - remove duplicates

    My first post...but I use this site all the time to figure out Excel issues...thanks for all the tips and help! I'm struggling with a case sensitive Vlookup....as I look for duplicate data I really hope someone can help: I have two sheets with data: 1. Sheet1 2. Sheet2 On Sheet1, I have...
  8. S

    Matching a partial string

    Hi, First time here, I hope somebody can help me. I have 2 Columns, in Column A I have a string that is 12 characters in length (fixed), in column B I could have exactly the same string, I need to make sure that A2 string = B2, A3 =B3 etc..... if I use the exact function this replies with a...
  9. C

    EXACT function - can't find difference between cells

    Hi there, I have a very basic query. I have a large data table and am trying to match names for use with the sum product formula. When I run the EXACT function on the 2 columns of names I receive a FALSE value. The columns of names appear to match. I have used TRIM to remove spaces and LEN to...
  10. K

    Populate value from a row if it is a number

    I need a formula which will search through a row and if it doesn't say #N/A #N/A then it will populate with that cell. Does anyone know of such a formula to make this work? Many thanks!!!
  11. D

    Drag formula across columns

    I want to do an exact match of 3 pairs of columns with values row a and b,row c and d , row e and f. If i put the formula in row g for row and a and b can i drag the formula across h and i for the other 2 pairs of columns to save doing it manually thanks
  12. R

    How to lock cell reference when using EXACT fx

    Hi all, I have a spreadsheet that evaluates cells against eachother and if they don't match I either delete the whole row, or delete up. When I do this, I have to redo the formula as I get an error. So I start with: =EXACT(A1,G1).... and once I delete a row or delete "up", I get...
  13. F

    Extract data within 1 cell

    Hi all I have this data in one cell "L/L Helvatica font 2mg Vit (2ddd)" 1. i just want to exact "Helvatica" , first 3+1 letter space is fixed. i mean before the helvatica 4 letter space will be always there. 2. i want the data within first two spaces "Helvatica" Please help
  14. N

    Macro to delete rows that contain values of exact but opposite value

    Hi, I am looking for a macro to delete rows where there is another row in the worksheet that has the exact same value but is opposite Eg. Column 1 Column 2 Column 3 Date Description Amount 01/01/2013 Deposit $100.00...
  15. N

    Find majority match in groups of cells

    I'm analyzing Mechanical Turk results. Each assignment was done three times, and I want to find all sets of three assignments that were agreed upon by the majority (2/3 or 3/3) of respondents. Here's the basic setup: <tbody> NAME STATUS Org 1 active Org 1 not.active Org 1 not.active...
  16. A

    Vlookup for data (yield only numeric values)

    I am working on a spreadsheet and need to automate data reporting. I update the spreadsheet with data on a daily basis. Consider the table below: <tbody> A B 1 2 Wednesday, December 26, 2012 6300 3 Thursday, December 27, 2012 NC 4 Friday, December 28, 2012 NC 5 Monday, December...
  17. L

    VBA code to copy exact formula with some change

    Hello Everyone! This is the first time for me to ask for assistance regarding excel! and so I don't know which forum is the most helpful- I have tried one forum yesterday but no one gave me not even a hint- so I hope I get the required assistance here. I have an excel sheet with relatively...
  18. N

    Too many Arguments--INDEX issues

    =VLOOKUP($A$3, 'SAP Data'!$A$3:$A$7,1,FALSE,INDEX('SAP Data'!$AL$3:$AL$4805,SMALL(IF('SAP Data'!$AK$3:$AK$4805>=H3,IF('SAP Data'!$AK$3:$AK$4805<=N3,ROW('SAP Data'!$AL$3:$AL$4805)-ROW('SAP Data'!$AL$3)+1)),ROWS(H$3:H3)))) The above is the formula I'm using, just a little long. I'm using...
  19. B

    Academic challenge for advanced-users

    Heres an academic challenge. Unfortunately there's no prize other than Kudos and receiving credit for answering the challenge correctly: 1. CREATE A SPREADSHEET THAT WILL ANSWER THE FOLLOWING: Youre trying to buy an item at a Vending Machine that costs 95 cents. The machine requires EXACT...
  20. A

    Counting the number of times a string appears within a range of values

    Hello all, Before I start describing my problem, I have uploaded a screenshot of my worksheet to tinypic.com. You can see it here: http://oi51.tinypic.com/2j34ca9.jpg and also, here's the worksheet itself: http://gopile.us/hlc What I'm trying to calculate is in how many of the values - the...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top