john

Hi all, Below is my coding that helps me search for a word/name in a certain column and return data that relates to this word/name. The values are returned in a neat userform. The only issue I have is that the text I search for may not be unique. There may be 2 or 3 other instances of this...

Hello, I am trying to pull phone numbers on an excel sheet using the vlookup function, unfortunately - there is no unique identifier that is correct. Example: one persons name may read "John Billy Doe" on the one page but on the line with numbers it reads "Doe, John" or "Billy Doe John", "John...

Hello, Ok so what I am trying to do is, I have a total of 500. And I have different accounts I want the 500 to come out of like for example: (A1) (B1) (C1) Dan. 100. ¤ Bob. 50. ¤ Mark. 50. ¤ John. 25. ¤ Alex. 200. ¤...

Hi, I have a workbook with several sheets. The example used below is very simplified Each sheet of the workbook has several tables. Each table is composed the same way but there might be more or less names in the tables per sheet. For example sheet #1 might have 4 people. Sheet #2 might have...

I am wondering how can i find the latest information that meets my criteria, because all my table are run form a formula we the "Blank" cells will always read as a')', there fore i am having a Countif, Sumif, Maxif, etc issues, i am probably just typing my formula incorrectly. Based on the...

Hi, I have a workbook that lists all terms attended for each student as well as their GPA for that term in descending order. What I am trying to achieve is target the top entry for each student, which will give me the last term attended as well as their last known GPA. Please see a short example...

I am hoping to create a way to hide rows on multiple sheets based off the text in the currently highlighted cell. So, for instance if I am on Sheet 1 and I am highlighting a cell containing "John Smith", I want to hit a button (from developer inserts) and it will hide all rows (across all 5...

Hoping there is someone out there, with a genius mind in VBA or excel formulas. I data set: <tbody> Name Location Outcome Kris Barbados W John Glasgow L Kris Birmingham W John Barbados L Kris Birmingham W Kris London L Kris London W Kris London L John London W </tbody> I...

I have been searching for a code that does what I am hopeful is understandable to whomever may be able to help me with this. I have multiple columns with multiple names (10 columns in this case), some names are duplicated, and need to generate all possible combinations of these 10 columns of...

Hi, Every month a sales report is pulled showing all activity for each sales person from the beginning of the year. This tab is the total sales overview. It is sorted alphabetical per sales person. Then a tab is created per sales person. Each of these sales person tabs needs to reflect all...

Dears, I would like to kindly ask you for your advice regards vba code. I need to assure that use right data. As I'm just beginner, not sure how to proceed with that... When push the button, data(text) in column A will be checked for equality. If all the same, run preview before printing. If...

Hi there, Maybe someone can help me (is there any video/page I can watch?) as I am struggling to accomplish the following: I have a huge list with post codes: DN9 2BT IP28 8PQ DT6 4NG F94 TP9N LL20 8DD RH1 2NB YO22 5NH TA8 2NZ B48 7SQ LL58 8YL In the second column I want to insert a if...

Hi guys, I've searched high and low for a solution to my specific problem, but to no avail. Hence this post. I am developing an Excel database of drivers and the trucks they drove. These entries are being made via a userform throughout the month as they use the truck. The basic table as...

I have a list of positions for employees that are in one cell that I needs to be in rows for each employee. Text to column doesn't work and neither does any sort of text formula like =left, =mid, etc. I have over 2500 employees and th <tbody> Active Status Emp ID Worker Hire Date Position ID...

Hi guys This is a bit too complex for me and I’m not too sure if it’spossible using excel. I have 3 columns I want to compare Column A = Clients Column G = Amounts Column N = Case ID So let’s say Client | Amount | Case ID Mike | 50|123 John | -50 |123 Mike | 50 |123 Mike |...

I have a lists of names in the range A8:F35. Each column A through F has a different set of names, but they may appear more than once. How do I display the names of those in the range more than 2 times in a different column? Ex. below: A.......B........C...................... D(Appears...

I am very new to Userforms and have learned all I know by researching examples. I'm thrilled with a userform I set up, but can't figure out one final detail. I have loaded a combo box with student names pre-loaded a worksheet using the following: Private Sub UserForm_Initialize() 'Empty...

Good day Have not posted here in ages but have a small problem In the sheet below there are for example five students who have arrived either "Late" or "On Time" for classes over a period of three days How do I calculate the percentage for each student of being "On Time" for the three days...

I have a table with several columns. The first is a name and the second is a date. For each name there are several dates. The dates should be sequential. If there is a gap of one or more days, I would like to add a line with the name and the missing date. <tbody> david 3/5/19 david 3/6/19...

Hi Experts, I need quick help. I can't share my real data however I have made up this dummy data. My real data has the similar pattern and have more than 10,000 rows. Thanks in advance for your help. Here is the problem. I have 2 sheets. SheetA and SheetB in the same workbook. SheetA...