aaaa

Hopefully I explain this clearly. I want to look up a value in Sheet1A5. Find that value in AA:AA on Sheet2, and then copy from that row in AA:AA down 6 rows and over to Column Z and paste it in A13 on Sheet2.

Hi Experts, I have account codes in column A, I want to separate them as follows, I am facing difficulty to apply formula to get in last column which is not fixed, please help I have applied in Column B =LEFT(A1,4) and Column C =MID(A1,5,4) but need formula in Column D to get remaining of...

Hello everybody. I've developped a code with a check at the end. Seemingly, everything is ok with aaaa = bbbb. But, as you can see by the highlighted part of the code in debug operation, vba is saying that aaaa is not = to bbbb https://imgur.com/7nsEQIQ Why?

I have data similar to below...I would need help in getting coutif formula ...I need count based on names and it should exclude the "Zero" value lines...for each amount type... I need one count for aaaa & bbbb and rest all other names should come under other names.... <colgroup><col><col...

Hi everybody. I am new, this is my first post. We in Spanish use a form of dates like: Viernes, 5 de Enero de 2018 (is like: Friday, 5 of January of 2018). In Excel I can use in order to obtain this format the following code: dddd, d "de" mmmm "de" aaaa But I don't know how to use this...

Hello Experts I have two sheets Sheet 1 xxx123sad AAAA dsfsdf124 BB Sheet 2 123 124 126 I want a formula in sheet2 column B to return the corresponding value in sheet 1 if sheet 2!columnA is found in the string in sheet 1!column A. ************************** The result should be...

Hi I'm trying to look from one table to another, to see if a match is found (easy enough with vlookup) but i want to match on Code first, then on a specific requirement and that requirement could be found in any one of 11 columns in one row and i'm struggling to do this so any help much...

Last time I asked here something this forum was very helpful, so I hope one of you can help me with my next problem. I have data in one sheet, with an ID number, Attributes that go with it and corresponding values. But one ID can have multiple attributes and values. And this data has to be...

Hi Everyone, I'm trying to figure out a vlookup that will display the first result & in the next cell, display the 2nd result, etc On One sheet (tab), There can be multiple rows of the same Employee ID & Customer Name. What I'm trying to do is on the "Employee" sheet (tab) is bring back only...

Hi All, I have a little bit of a tricky situation. I have two worksheets. Sheet1 contains a file name with claim numbers like below: <tbody> <tbody> File Name </tbody> <tbody> Date Created </tbody> <tbody> AAAA File name with additional characters.doc </tbody> <tbody>...

Hello Team, I have a data in excel with different columns in same sheet, for A, i have data from A to C for B , I have data from E to G and for others it continues.... with three columns for each. i need a help with macro to get the all the three columns of each in another sheet, as one...