brian

Hello I want to know why Combobox displays its first index value of 1 st item when searched if the items are duplicated repeated. Why cant it display its index value of its respective repeated item clicked on <tbody> Sr. No Name Add 1 Caroline Martin 2007 Excel Road 2 Brian Green 2010 VBA...

I have been watching your U-Tube regarding the creation of pivot table and dashboards and I followed your written materials and am having some problems creating the pivot table from the get go. So, will you be kind and please shed some light and offer some suggestions as to why I am not getting...

Hi All I know this will be pretty straight forward, but i'm struggling to ask the web the right question.. I have an array formula that brings back an "order number" in column E, based on the order date in column A...

I have been working on an Excel workbook for booking talks in various locations and a variety of talks. This is to replace a small database programme that only works on Windows systems (PC or laptop) and only allows me to look at 15 weeks worth of data at a time and doesn't allow me to easily...

I have a column with usually numeric digits and then a name of a person. I.e C11883 Dave Smith C11 Dave Jones D11111 William Brian Johnson I wish to create a new column removing the first word to give the results Dave Smith Dave Jones William Brian Johnson I have used the MiD...

Hello all..I'm trying to create an if statement that will look to the next row to fill in the data if it is false until it finds the true value. I can get it to find it but when I switch to the next value it leaves the first rows blank until it hits the true statement. Example - looking for...

Hello all, How can I use the Code() function in VBA e.g. Code(ActiveSheet.Range("A2")). Thanks, Brian

Hello All, I need a formula that is able to find to the last value (Excluding 0 and empty cells) and then divide it by the divider next to it. For example Allan's value must be -0.5 (row 8) because at the row 9 there is a 0. Brian's value must be -0.06667 because row 20 is zero and row 19 is...

I have removed all the Margins , Header & Footer... Thanx Brian

How can i invert the text of a cell?? Thanx Brian

Hi, I have multiple sheet in given workbook. Each sheet filled with Column A:E with same number of rows. I would like to combine all these sheets into one sheet and highlight the row for the column header named as "Order" with "Yes" option. Sheet1 <colgroup><col...

However when its 0:00 I'd like the cell to be empty. Hope u can help out. Thanx Brian

Hello Everyone! Ok, I am needing some help yet again. I am looking for a formula to do the following. F1 is a changeable field. If F1 ends in 10 (310) and G19=odd number I need G22=0. However, if F1 ends in 10 and G19=0 I need G22=1 Thank you Brian

Hi everyone, date day name check 1/11/17 wed andy OK 1/11/17 wed carl OK 2/11/17 thu andy 2/11/17 thu brian OK 2/11/17 thu carl 3/11/17 fri brian 3/11/17 fri dan OK 4/12/17 mon andy OK 4/12/17 mon dan OK...

Hi, I have been trying a formula to return row and column heading from table 1 including the cell value of the cell with value in it. I had been trying to follow this post ...

I have 2 reports, I want to use a key field to find the field into the other report and compare all columns after the key field, showing any differences. I'm looking for a formula to show on a different sheet the changes in list from day to day. Searching by the Name to find on the other...