Recent Questions

I have a list of data that I need to rearrange in a specific way in the next sheet. I want to make the data to automatically be inputted to the next sheet as below as the total data is actually a lot and it takes time to do this by transposing and copy pasting to the correct order. Is it possible to make the data be arranged as such automatically by functions/macros? Let's block ads! بخوانید...

Experts: Need an help - i want the excel pivot table to show each logically independent columns next to each other instead of sub level/nested. I can surely create multiple pivot table but would be ending up having 10+. So is it possible and if yes how? (tried google and videos but no help, so finally writing a post) Image of how i want it to look is here : Excel Pivot table Let's block ads! بخوانید...

I'll assume you're using a more recent version of Excel. To make a line graph of your data in the way you described, copy the data columns for MPH and RPM side-by-side in that order. Then select both columns. Click 'Insert' > 'line graph'. To add a trend line and formula for your data, right click on the newly made graph and click 'add trendline' in the dropdown menu. A panel should pop up on the right hand side of your screen with options for the different types of fittings (linear, exponential, logarithmic, etc.). Hope that helps! Let's block ads! بخوانید...

I am trying to compare data across multiple columns to see if each cell is less than a value in a single cell on the same row. Column B contains the mean across all employees for the variable in Column A (there are 12 variables). Columns C through N contain the mean for each individual employee. For each of the variables, I would like to highlight the cell for employees whose mean is less than the mean of all employees. I can figure out how to do this for each row (compare the values in columns C through N with the value in column B) using conditional formatting using a formula: If Cell Value is...

Please ref attached image. I need to align sales for the agents in single row to match their names. The problem is that in Jan the number 1 agent may be on 5th spot and in 12th place in the third month. I need to bring the agent and his corresponding sales in one row. Let's block ads! بخوانید...

I got an excell sheet with 3 worksheets that I update like every 2-3 days manually by dropping down the date column and it automatically updates the columns based on the date. For example; lets say I opened the excel on april 4th what I do is I drop down the date and until today -1 and following columns gets updated automatically. I basically add in 2 more rows to the worksheet and and columns get updated based on the date. 01.04.2016 12 15 16 19 I would like to make a macro which adds in those needed rows (If i no one updated the excel for like 10 days it needs to add in 9 rows etc) when I hit the button for 3 worksheets at once. Thanks alot. Let's block ads! بخوانید...

I am looking to split a column array interspersed with zeros into separate columns in Excel while breaking at the zeros in the column and ignoring the zeros. For example, if I have an array {1,2,3,0,4,5,0,0,6,7,0}, Excel should retu three arrays - array 1 should be {1,2,3}, array 2 should be {4,5}, and array 3 should {6,7}. How can I do this in excel? Let's block ads! بخوانید...

I have an excel file (see the picture) for which I want to specifically arrange my data. What I want is "col1" to be arranged from the most past date, so 5/1/2016 then 5/2/2016 and so on. With that, I want "col2" to have everything in alphabetical ascending order, and the dates in "col3" to be just like in "col1". The key column is "col1" meaning everything needs to based on that. I did it manually, but I can't do that with 1000 lines in excel. Let's block ads! بخوانید...

I want to know if I can swap columns in excel, by swapping I don't mean only swapping contents of the column but column name also. For example, I have empty excel with column names in order: A B C D E .... new excel file: Can I swap column A and D for example so order will be D B C A E ... Please advice. Let's block ads! بخوانید...

Input : MACK 113 445 25 JACK 345 PIKER 30 23 I want the output to be : MACK 113 MACK 445 MACK 25 JACK 345 PIKER 30 PIKER 23 Can anyone please help me out . Thanks in advance....

Say I have some Excel columns that look like this: A B C D 1 Amy Bob Carol David 2 Carol David David Carol 3 Bob Carol Amy Amy 4 David Amy David Amy I need to count the number of rows where both Amy and Bob occur, no matter which column they are in. In this example, the number should be 2 (row 1 and row 3). I already know COUNTIFS with which I can count the number of rows with 'Amy' in column A (or any particular column), and 'Bob' in column B (or any particular column). The formula would be: =COUNTIFS(A1:A4,"Amy",B1:B4,"Bob") However, this formula seems to require you to specify the columns. I tried to change it to =COUNTIFS(A1:B4,"Amy",A1:B4,"Bob") and it retued 0, which is not what I'm af...

If you try to sort on a column when there is a blank column, only the columns before the column will be sorted. How can this be changed so that all columns are sorted regardless of whether there are any blank columns?...

For example I have the following two rows: X Y Z A B C X Y I want to merge across so the result is centered across the 2 rows like this: X Y Z A B C Please help!...

Hi I have hundreds of contacts in a single column in xlsx 2016. An example is shown below in the link, (sorry can't embed pic) link to screenshot of data What I need to do is bring all the data into individual columns as shown below Col 1: Company Name, Col 2: Address, Col 3: Reg Head, Col 4: Tel Col 5 Fax: Col 7: Email To throw a spaer in the works some addresses spread over 2 rows. Any help is appreciated Thx Let's block ads! بخوانید...

I am attempting to have two columns equal each other in excel. The first column (AC) has the value "." and the second column (BA) has the value "0". I want something that says if BA=0 then AC is a match to it. I am doing some comparisons and because of this difference the comparisons are not recognizing that these two are actually a match. There are around 18,000 rows on this so I'm hoping to do an IF/THEN formula rather than change all of the 0s. Can someone please help me? Let's block ads! بخوانید...