comparison

have sheet with now() in A1 and timevalue(9:00") in A2 need to perform an operation in other cells based on a comparison of the two cells. the following formula returns the #value error. =IF(RIGHT(A1,9)>A2,B4,C6) any help greatly appreciated

I need to compare to columns using index/match but round each value before comparison. Could create a dummy column but that is very cumbersome and ugly. is there a way to perform an operation on each cell value before the comparison =match(round(a6,1),Sheet!A6:A1000) I need...

Hello, I have a datasheet with 35000 datas in one column and I have to compare it with another colomn that contain 10-15 lines. The problem is that the way they are written are not the same. For example in one column I have : Microsoft Visual C++ 2008 Redistributable - x86...

Hi Excel Experts, I need some help creating VBA code that will accomplish a very repetitive task. I have 2 sheets of data, I need to compare Sheet 1 to a specific range on Sheet 2 and where a value from that range on Sheet 2 appears in the PIO String (column 3) it needs to be removed from the...

Wrote this mass of VBA code in order to compare sentences for equality. Any recommendations for speeding it up? Not looking to use other programs (though it would be easier) as VBA is the only current one I have access to. Looking for better algorithms for assignment issue as well as removing...

Is there any way to compare the players of 2 cricket team in excel basis of their last performance, ground, team etc? I have csv files of each player downloaded from ESPN stat guru.

Hi all, I'm comparing two cells data (G50 and G66) to see if they're equal, each is calculated via a formula, and the results are not correct. The comparison formula is =IF(G50<>G66,1,0). Both cells data evaluates to £12499.00, so therefore I'm expecting the result of the comparison formula to...

Hello, I am looking for code to take a comparison of one worksheet with all the data to the 7 worksheets with the original data. Can someone help with a code that allows me to place a phrase with address of original next to the comparison or even onto a new worksheet? All the data is in 1...

Hi All, Could do with some assistance in improving the view of a comparison chart for data similar to below <colgroup><col span="2"><col><col><col></colgroup><tbody> Prog Week past fixed point open closed Prog 1 13 1 6 3 15 2 5 2 Prog 2 13 3 4 1 15 4 3 4 Prog 3 13 5 2 5 15 6...

Hello, I hope y'all doing well. I am having a hard time trying to get a pivot graph showing a Plan vs Actual based on counts of ID's and dates. <tbody> ID ID_Name Status Plan Date Actual Date 1 UAT Pass 1/28/2018 1/30/2018 2 SmokeTest Fail 1/31/2018 1/30/2018 3 YourCodeIsBadTest Fail...

Hi Everyone, pretty amateur excel user, hope somebody can help me out. I am trying to input some kind of formula that can solve the following Problem: there are 3 columns A: Rank1 B: Rank2 C: COUNT. The idea is to compare the value in Rank 1 cell with the values in the rest of Vector...

I have a 'master' sheet that contains a big Table with several columns (A:G) and 283 rows (with header). The other Sheets contain sections of this 'master' table based on unique values in Column B (i.e. Column B is filled with names like 'dog' 'cat' 'pig' 'horse' etc. and these could appear...

I'm a bit puzzled by a couple of the Compare options for the Split function. According to this link: https://msdn.microsoft.com/en-us/vba/language-reference-vba/articles/split-function The Compare option has these values: <tbody> Value Variable Description -1 vbUseCompareOption Performs...

Hello, I'm looking to produce a simple (well I say simple, I've been playing with this for a while and just can't get it right) comparison workbook where I can copy/paste an extract from our own internal systems of company names and unique IDs in one sheet. Then in another I'm entering details...

Excel 2007/Windows 7 Pro. Thanks in advance. I have dates arranged in columns and I would like to compare column B to column A, column C to column B, column D to column C, and so on up to column n compared to column (n-1). See example table below. Easy enough to compare with, for example...

I was going to quickly mock up some logic in excel for another project I'm working on and ran into a problem I cant solve without creating dependency loops. I'm looking for a less than comparison with a bias: =IF(X1"<"Y1,1,0) and would remain true until: =IF(X1">"Y1+B1,1,0) Here is as close as...

Hi, I am trying to find the way to compare products costs between 3 vendors against mine and generate a sell rate with the best profit possible. So, for example the best competitor cost is $1 and mine is $ 0.50, I want to generate a rate to be close and below to $1. Do you know any macro or...

Hi, So I am creating an inventory workbook, which I receive my inventory data from a POS system that allows me to export to Excel. What I am trying to do is automate a process that compares one report to another report(ran a couple days later) and allow it to tell me which products are not in...

Hi All, Request your help in understanding in the below requirement and please let me know if there's a suitable formula for it to be executed:- Would like to compare two columns and if the value in first column gets exceeded or equal to when compared with the second then it needs to be...

Selecting item(product) from Drop Down List auto fills 4 cells below it with items ( competitor products) that are similar(generic) to product selected in the drop down.