Search results

OK thank you, vletm. I will also implement the Clean() Function.

I'm not sure what a clean-function is. What is that?

You know You could be right? I tried adding a trim() function to the formula in the test column and it worked for the "Bennett peter jr" Error case. - So additional spaces could throw off the check. I was not thinking within those lines. Thanks for the additional error case Vletm. Thanks...

Hello Friends, - I have recently observed an issue regarding my data in a column that I use to perform data validation on my spreadsheet. - So There is nothing wrong with the formula, neither is there anything from with the use of data validation. - It should be looking for duplicate entries...

Thank you Hui and p45ca,l this solved the problem. However I wanted the file to also be smartphone usable, is this possible?

Hello guys I hope there is a non vba solution for this problem: Suppose I have a workbook with cells containing text. Can I Display each cell content in 1 other cell after selecting the cell I want to display? so each cell will be displayed in that particular cell whenever it is selected. for...

I am sorry man, it is just a communication issue. I thought you were asking if I need to switch between hover/select using Yes/No. Ok so to answer your question: you could probably try hover yes/now.... Let me see what you are thinking.

Ok well the I should be using a galaxy s6 or a nokia plus which are both android phones (so basically android platform). So as I said I am not necessarily looking for both features to work at the same time (Ie hover & select). If I can get both no problem but I am strickly looking for a...

Plus I'm still learning to be more specific..... should have really said hover/select.... which would not mislead other web users... work in progress.

Okay Thanks for that comment. I Usually don't Make post like those. I am kinda unfamiliar with this forum and also with how excel works to some extent. Hence, my upload of a macro enabled sheet, and also taking for granted that it would work on my smart phone with out testing. Please forgive...

Okay. Well, any of these options (hover/select) would be fine for me I just need a workable one, that displays the name values whenever I enter its respective number

Okay, I am now understanding your solution. This is not really what i am looking for, the name values here would "crowed" the sheet, and would not look as neat. I just need a little 5 or 6 seconds name display whenever I select/hover the number of the relevant cell (after it is entered). Thank...

No this is not what I'm looking for.

I just tried the file on my smartphone (android) and when I selected a link (in col A) there was a pop up saying "open link" which had further options when selected. It wud be nice to see the reference value "Dermot" (on sheet 2) instead of "open link". This wud be perfect!

Can I see a comment or a similar text display setting display the cell's reference value whenever I select that cell? So if I have a column A for example having the values shown below, I would want to see the name values next to column C displayed when I select each cell in column A. Note, I...

Het guys I am so sorry I have to revamp this question. I sent an .xlm that had vba code. I had no idea I did, so the sheet cannot be functional on a phone using the excel app. and I want it solely for this purpose. And used my phone and tried the sample code and it did not work. So its is what...

I Dont want to use code in this spreadsheet because I want it to phone usable

I Am not seeing the cell values (names) displayed. however is seems like it is a workable solution, only that I really don't understand it. can you give me more details on the excel file you posted vletm? it is giving me a "cannot open specified file" error vletm vletm

Hello all, I have scoured the the net to find a none VBA method of displaying a cell value from another cell by hovering over the active cell. just as how "Khalid NGO Excel Ninja" gave an example using a hyperlink (Right Click > Insert > Hyperlink > Place in This doc > ScreenTip), my result...