mike

Hi I want to put a button on the ribbon that will hide and unhide column. I don’t need a password. I want it to toggle each time I click on it First click>>unhide second click>>hide Sub unhide() Columns("a:a").EntireColumn.Select Selection.EntireColumn.Hidden = False End Sub...

I'm trying to write a VBA script that will turn table A into Table B Table A: <tbody>#FAFAFA[/URL] "] #FAFAFA[/URL] "] Name Animal #FAFAFA[/URL] "] Mike Dog #FAFAFA[/URL] "] Mike Cat #FAFAFA[/URL] "] Mike Mouse #FAFAFA[/URL] "] Mike Rat #FAFAFA[/URL] "] Mike Chicken #FAFAFA[/URL] "]...

Hello, I'm trying to find a formula (Or VBA, but i have close to zero experience on that) that retrieves me a series of random samples based on a weighted criteria. Let's say i have the following Table <tbody> Jon 1 Mike 2 Jon 3 Jon 4 Jon 5 Mike 6 Mike 7 Zero 8 Zero 9 Jon...

Is it possible with some sort of formula to only add negative values? I can't think of any way of doing it. This is the table, values are in cell B2 through B7 John Doe -35.75 Mike Smith 9.05 Jason Hill 21.48 Mark G 23.02 Mike Frot -25.92 Jimmy Smith -26.17 In Cell F2 I would like the...

Hi all, Currently having an issue converting orders to a spreadsheet. I am under the assumption that Index Match would be the best route, however due to the fact that there are numerous times that the customer number appears in the list of orders, I need to match it up with dates. This is...

<tbody> Dear All, I have data as per below and I want to make a summary in VBA, like the table on the right side in bold, which shows by Name, by category the values sold and it should be by month, but my dates are as per below, so if i have January then it should be 31 columns. I have...

I am attempting to have several users input onto different sheets. What I would like to create a sheet that has a running list that will update as inputs are put in? This is not actually done in microsoft Excel. It is being done in Google sheets. Example Sheet 1 Sheet 2 Sheet 3...

I have two column in excel I want find column differences ; I have below two column I want to find out based on the employee name check entire Manager column find any differences in manager name. Emp Name Manger Mike John Mike Victor

hi all how to hide a row if in column F exist a cell that contains these word: "Mike" if F5 = "Mike" and F18 = "Mike" i want hide row 5 and 18, how to? thanks

Hi I'm having a brain fart :) A433 has a date in it formatted as mm/dd/yy I put this in G433 and got #VALUE ! =IF(AND(A433="",""),IF(A433>=TODAY(),"pending","payment")) What don't I see?? Mike

I am having trouble getting my conditional formatting to work. I am trying to highlight the first occurrence of value in a range of D19:I137. I tried condition formatting duplicate value and it changed all occurrences to the same color. I also tried entering a formula but still can't get it...

I have cells A1 with dates such as 1/2/18 I have cell B1 with names (some are duplicate) I am trying to figure out away to count how many (unique) names worked on per day of the month. I can not figure out how to do this. I have tried using the .. =SUMPRODUCT(1/COUNTIF(A1:A22,A1:A22)) I can...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> Hi, Application.Goto Reference:="R3C14" Instead of using R3C14 in a macro, is the a way to cell reference, like N3 It would be easier for me :) Mike...

I am trying to add onto a current VBA script to do the following: The name itself and the number of names will be different each time the script is ran. Before <tbody> Name Animal Mike Elephant Mike Dragon Mike Dog Mike Cat Mike Mourse Mike Bird Mike Hawk April Lion April...

I am trying to calculate the power consumption on my computer, monitor, Refrigerator, TV's and portable air conditioner. I am looking for a formula that I can take information from the devices to calculate the usage. Thanks, Mike

Hello! I have a sheet containing rows with data. In the B column of each row there is a word written, sometimes with small caps, sometimes with all caps and sometimes with both. I would like excel to automatically (without button) show the B and D column of rows containing only all caps words in...

hello, can i actually use match-function looking for a single item if it is located on multiple worksheets? thank you. Mike

Hi All, I am trying to find a result by search multiple columns of a table. For example, see the table below. I wish to search the employees and firstly find the youngest employee (Col C). If there are multiple employees with the same age, I then seek to further narrow those employees with the...

I am defiantly new to macros. i have learned a lot from this forum but cant seem to figure out how to write this macro. I am trying to take 3 player from each weekly results based on the previous week. For example, the first week the top 3 players would qualify. In the second week if any of the...

Hello Again! Sorry if it is a bit confusing . Example on sheet 1 i have . <tbody> Name date Start End Mike 09/19/2017 12:16 am 3:35 am John 09/19/2017 1:39 am 2:00 am </tbody> what i want it to look like is the table on sheet 2, i have a table on sheet 2 that looks like below but...