Search results

Hi Thanks a lot, it was a great help. Best Regards

Hi Thank You. Link to the file is: https://docs.google.com/open?id=0BwqQW589JCh7YTZmNWViOGYtMDYxMS00YmVhLTlkZjYtNWI3MjdiYTQ0ZjM3 Data is in 3 columns: Column A is titled MyData, where Columns B and C are untitled, It looks like this: MyData (5,1) 5 (7,1) 6 (5,1)...

Hi Can you please tell me how can i upload my Excel file on this Forum? I think that will clarify my question and would make it easy to get help from you. Best Regards

Hi Everyone I have data in following form: (5,1) (7,1) (5,1) Duplicate (19,1) (7,1) Duplicate (33,1) (41,1) (33,1) Duplicate I want to remove duplicate entries from the Data, so that the remaining Data should be: (5,1) (7,1) (19,1) (33,1) (41,1) Can anybody please explain...

Hi Thank you for the help. Best Regards

Hi Everyone I have some data in a cell in the form: 0 0 0 0 0 0 0 0 0 0 9 0 0 I want to move it to a column and each number goes to exactly one cell of the column.The final output should be like this: 0 0 0 0 0 0 0 0 0 0 9 0 0...

Dear "Luke M" Thanks a lot. The problem has been solved. Best Regards

Hi Everyone I have data in a column like below: 3 5 8 I want to add 1 in each cell so that it becomes: 4 6 9 Kindly guide me how can it be done? Best Regards

Dear "Hui","Key Master" & specially "Luke M" Thank you very much. The problem has been solved. Best Regards

Dear Luke M Below is the error which i get when i paste the formula in the Excel worksheet: Microsoft Office found an error in the formula you entered. Do you want to accept the correction proposed below...

Dear Luke M Thank you once again. I typed in the new formula but MS Excel showed an error and i applied the auto correction suggested by MS Excel. But, still the formula only works for single digit numbers (6,1) & (1,6). But if the number of digits exceed 1 i.e 2 (e.g. 10) or 3 (e.g. 100)...

Dear "Key Master" & "Luke M" Thank you for your earlier replies. Can you please guide me what change should be made if the data is of more than one digit (two or max 3, the maximum digit in my data is "100"). E.g. (6,10) (10,6) Your solution works perfectly fine if the data is of single...

Dear "Luke M" Thank you for your earlier reply. I tried your solution but it did not work, maybe because of the following reason: The data is in the following form: (6,1) 74 (7,1) 25 (9,1) 35 (1,6) 74 The value (6,1) 74 is in cell A2 and so on. Now the values in Cells A2 and A5 are the...

Hi Everyone I want to filter out duplicate data from a single column in Excel worksheet. The data is in the following form: (6,1) (7,1) (9,1) (1,6) In this data (1,6) and (6,1) mean the same thing. So i want to filter out one of them and the resultant data in the column should only...

Hi Thank You Best Regards

Hi All I have a very simple question. Suppose i have data in one of the columns in the Excel Sheet in the following form: 10 24 5 6 8 15 20 I just want to know how many numbers are less than 10(e.g. in above data there are 3 entries which are less than 10). Which formula or condition...

Hi Thank You for the reply. I want to have 2 comparisons on the same chart like i mentioned above: Column B & G Column C & H The comparison will be between columns B & G, and C & H (no divisions or any other arithmetic operation) It would be good if i can send you some sample data in...

Hi I am new to this forum. I want to make a comparison between different columns of a single spread-sheet in the following manner: Column B & G Column C & H I want to draw a single chart as a result of this comparison between different columns. Can anybody please guide me how to do...