excel 2013

List of data col A with different values input into the appropriate col C-F. I want to have B reference the column header the value is in. So in this example rows A2-A8 are my line items where their values are recorded in the appropriate product column, and I want that product column header to...

I am trying for formula in excel to split the word in to digits on each separate cell in same row, as described below. B10 = Mirza Bahadur Ali Result Required: C10 = M, D10 = i, E10 = r, F10 =z, G10 = a, <No Space> H10 = B, I10 =a , J10 = h, K10 = a,L10 =d , M10 = u,N10 = r, <No Space> O10 =...

Days of the week Sunday Monday Tuesday Wednesday Thursday Friday Saturday Days Number Day =IFERROR(IF(A10=1,A2, IF(A10=2,A3,IF(A10=3,A4,IF(A10=4,A4,IF(A10=5,A6,IF(A10=6,A7,IF(A10=7,A8))))))), "PLEASE ENTER NUMBERS BETWEEN 1AND 7")...

Hello, Can someone help me with the following, I want to build a VBA Macro which allows me to : The Macro would verify if (for the rows with an « x » in a specific columns) some cells contain effectively a value (for example a date or a six digit number or some specific text character) in...

Good day. Been struggling with this and would appreciate some help. I'd like to write a macro that goes through multiple columns in a sheet and sums the total values of each item beside it's cell in a unique list. Similar to how to find for eg. sum of total sales for multiple months for a...

So, i have a 'Summary' workbook that consists of zone, state, city, and total income. Inside one zone, there are a states. And inside the states, there are a cities. What i'm trying to do is to find the total income of each city in column D and summarize the total income of each state. To get...

Hi One of my colleagues has asked if it's possible to add a column in Excel which increments a number every time a value is entered in another column. In other words, he wants the Excel equivalent of an autonumber field in Access. The number would be unique, and 'permanent' in the sense that...

I have the following code. Within the range B4-P4 are the days of the week (Monday-Sunday) and I'm trying to limit the characters so that it will say (Mon-Sun). I'm not sure if .Left is the right property to use so if anyone has any other ideas, please offer them! With Range("B4:P4")...

Hi Everyone, First time poster here, and man do I need some help. I am working on re-creating an "Activity Workbook" for my team to use at work. The original Workbook was created some years ago by someone who no longer works for my company, and it is in desperate need of updating. No one on...

I am trying to create or find a VBA code that will allow me to copy row 1 on the sheet and paste the entire row in each blank cell in range A3:A177. I have data in random places throughout, so I can't put just every so many rows or cells. I need to run this macro after pasting the information on...

Hi, I got this here, =SUM(IF("Jennifer"=$B$5:$B$26,1/(COUNTIFS($B$5:$B$26,"Jennifer",$C$5:$C$26,$C$5:$C$26)),0)) Is it possible to amend this formula without CSE to get the same result?

Hello There, Just started to learn the pivot table. While playing around to understand it. I have this problem. While transforming some data, columns to rows, duplicate values are not merging & not showing the correct sum. I have highlighted the cell in yellow. Pivot Table...

Hi Guys, I need help to compare 3 columns (G, H, I) values with many rows & want to keep all the unique value with the first duplicate. Here below what am I looking for? If there is any formula without CTRL+SHIFT+ENTER will be better. Also, I don't want to have a blank cell in between, the...

Hi Experts, I need help with the below issue. I have data in A2:D5, I will divide each cell by a value let say 40 or anything. What I need is a bit different, kindly see the below example. ABCDEFGHIJK1SMLXLRESULT DIVIDED BY 40REQUREMENTULTIMATE RESULT2180400.025021IF RESULT IS <1 OR PRIME...

I have some specific cells locked and others unlocked. When I manually protect the worksheet, I cannot select the locked cells, which is what I am looking for. This is the correct behavior. I have some code that runs when I open a workbook and when I close the workbook. The code basically...

I have some simple code that I have used previously. I have adapted to a different circumstance, however, I am not getting the desired effect. Here is the code: Private Sub Worksheet_Change(ByVal Target As Range) Dim cell As Range Rows.AutoFit On Error GoTo...

I am using Excel 2013 desktop and trying to insert traffic light colours in certain cells. I did the following: Click Home on the ribbon, then Conditional Formatting, highlight cell rules, then equal to in the pop up box type the letter R (or A or G) click the drop down menu on the right &...

I have a few columns and couple thousand rows. Name Location Status Action Jake Germany out Retain Jake Ethiopia out Delete Jake Germany in Retain Jake Germany out Retain Jake Ethiopia out Delete In the above table, if Jake is "in" (3rd column) "Germany" (just an...

Excel vba will not recognise that AutoFilter is enabled. However, it works on the initial sheet which the code is run from. Using code: If ActiveSheet.AutoFilterMode Then Option 1 Else Option 2 End If I have tried to use vba prior to the above code, to remove and re-add the...

Good morning, I'm trying to get this function to work, however I'm running into some issues. I'm trying to search multiple model numbers in an array using the SEARCH function, and display output using the IF function. When doing this I can only get SEARCH to find the first value in the array...