daniel

Hi all wondering if someone could help me out. What im trying to do seem simple but i was unable to figure it out with either a formula or a macro any help would be greatly appreciated here's my problem I would like to have value from Sheet(1) column C and value from Sheet(2) Column E...

Hi All - I have a range of data spanning four columns. In these four columns, there are values that are similar. <tbody> Bill Chris John Mike James Bill Chris Charles Daniel Daniel Daniel Mark Ken Michael James Steve Ed Kevin Jason Gary Larry Jeffrey Steve Ed </tbody> One of the...

Hi All Have done a lot of searching and cant find an answer as to why my formula is returning #Value =SUMPRODUCT(--('1.RevenueRec'!$B$2:$C$10000=B$1),--('1.RevenueRec'!$A$2:$A$10000=$A3),'1.RevenueRec'!$I$2:$I$10000) I have checked and double checked column I in my data sheet, they are all...

I'll do my best to phrase this - I have a table, see below. I have a table similar to below, in cells A9 and B8, I want to be able to edit the names to any of the names in the table, and have it return the appropriate value. E.g, If I change the names to Bob and Pete, it should show the value...

Dear All, I need a Conditional Formatting Formula to indicate the additional Duplicated Entries in different color, the first entry should be in default color the additional entry only in different color. Daniel Jose Daniel Maria Jack Jose Thanks a lot

HI i am using a form to get an email for a list of preferred names. the list comes back to me in the order that the user has chosen but it has leading numbers on it (see below) is there a formula i can run to cut off the leading number, the : and the blank space so that the first character is...

Hi I have downloaded this macro to export data from excel to a csv file. Everything works fine except when the date and time is exported. It seems that the date and time formats of excel is ignored are there a way of incoporating it in this macro? any feedback would be appreciated Daniel...