exact

Hi, I would like a macro that would: 1. Search for specific exact text in a specific column (often will be multiple matches). 2. If it encounters an exact match in that specific column, it will move the complete row to another specific worksheet (to be placed at the next available row that...

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.

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

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...

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...

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

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...

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...

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...

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...

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!!!

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

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...

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

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...

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...

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...

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...

=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...

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...