uhhm..
1. if i copy the values( ex: -214 -568.59 ) from a file and
2. paste it in excel
Instead of having it placed on the two different cell with result (-214 -568.59)
3. the result is "(782.6)" and in the formula bar "=-214 -568.59"
which is equal to the sum of the values
can you help me...
so i got this data from a PDF file. But when i copy and then paste it in excel. It was "auto summing" the values(since they are both numbers) where it should be separated by Columns. Can you tell me how can i disable it?
Thank you.
Hi Sir, as you can see with the attachment, In Cell M5, the result is "Earth Spirit" "Previous" Column since it is the one with the highest duplicate from cell "G5:L5"
I want to know the formula wherein Earth spirit or the one with the most number of duplicate will directly be the result for...
Hi sir.
I know its easy but i don't know what formula to use to "Find find the Text with the highest number of duplicate text entries"
http://forum.chandoo.org/threads/find-the-text-with-the-highest-number-of-duplicate-text-entries.34085/
I know its easy but i don't know what formula to use to "Find find the Text with the highest number of duplicate text entries"
The result should be posted in Column N "Result"
Thank you very much.
Hi sir,
Thank you for your reply. Sorry to say but it seems not working out.
P.S. I also observed the difference in our file that what you sent me is a .xlsm and not .xlsx - could that be the problem.
Thank you.
Hi ma'am Srinidhi,
Thank you ma'am, I like how awesome the results come up. But sometimes it is kinda Lag, or is it my computer who has a problem or the formulas doing this? Anyway, is it possible to make it with this with this whole data madam?
Please see attached file.
Thanks a lot ma'am.
Good day,
I would like to ask if there is a shortcut instead of clicking from your filter button and choosing what you want to filter. Recently my right arm is getting numb due to too much clicking and choosing from the list.
So what i want to know is a FORMULA that If ever I input the Store...