Guys!
Thank you everybody for your awesome replies and all the help that you provided!
Haseeb, your formula really helped out and it solves the problem in a single step! Thanks a ton!
Swapnil and Bhawani, thanks a lot for your inputs! Really appreciate your help and multiple inputs and the...
Hi Bhawani,
Thanks for your help! I am not able to understand the process.
PFA a file that i have uploaded showing an example of the problem with the steps involved. Please let me know if this would help?
Cheers!
Hi Guys,
I have a problem which seems rather easy, however I can't arrive at the solution.
Suppose you have two cols. Column A contains around 3000 names. And corresponding to every name, you have a certain value assigned which is in column B.
Now, I sort column B in descending order. I now...
@Faseeh : I cant thank you enough man! immense help. My problem sorted and now i shall get back to doing whatever i was doing except in probably 1/3rd the time because of your help.
@Raja : I never realised about the special characters.
the "," and the "." could be mistaken to be a part of...
Faseeh : the link for the sample work book is : https://www.dropbox.com/s/inkasel5cl9u02c/sample%20for%20upload.xlsx
Debraj : Debraj, I have tried that and unfortunately it doesnt work.
Thanks!
Abhiroop
Hi Narayan,
I followed your procedure wrt to the formula =TYPE(A2) and to numbers that excel wasnt reading are appearing as 2 and the numbers that excel is reading is appearing as 1.
However, when i try to change the cells from text to numbers, there is no change. I did it in the following...
Hi,
i am stuck on a particular point. The problem i am facing is that excel is reading only certain numbers from a column of numbers and ignoring the remaining numbers.
as an example, i have the following numbers :
1000
2000
3000
The problem is excel only reads the number 2000 and not...
Hi,
I have created a chart in excel with some data. I then copy pasted the chart on a slide in powerpoint and mailed and it to my colleague. The problem that i face is :
When i try to edit the data on the chart, i am able to do so as i have the source excel file present with me. However, when...