1-5

I have a pivot table in which the first column looks like this: 1 2 3 4 5 ... 50 If I group them in increments of 5, I get the following: 1-5 6-10 11-15 ... 46-50 I would like to group like this: 1-5 2-6 3-7 4-8 5-9 6-10 ... 46-50

I've created a box on my data entry UserForm for entering 1 of 5 numbers Once the "Submit" button is clicked, how can I make that number entered direct the data entries to the corresponding sheet? Example: UserForm. 2 is entered. Data is entered. Submit. The data is now listed on...

Hello All, Novice Here I am trying to use a formula that will assign a value based on the words it finds in the table. I am not sure what I am missing. I want the resulting value 1-5 to appear in the "Raw" column. The table below is the mock up of what I am looking to do. =IF([@Answer]=""...

I was given a data set with a Likert scale (rating 1-5). The data set has around 270 participants, and 8 questions (all with the rating of 1-5). The data has been coded (so it looks like it was taken straight out of Access- including the auto number feature on the far left). However, I need...

Hi, I have 3 tables in 3 different worksheets. I want to setup a Macro to copy and paste the data from all 3 tables into another workbook (pre-existing), pasting one below the other and keeping the set of headings from the first table. The headings of the 3 tables are all identical. The...

Hello, I help to generate a formula that will select an answer from a list (1-5) from the following range: 5= 0 to 4 hours 4= 4.01 to 12 hours 3= 12.01 to 24 hours 2= 24.01 to 28 hours 1= 28.01+ hours I already have the calculation formula to generate the total number of hours. Now I need a...

Hi In this excel sheet, there is a column called "Satisfaction on management" (in Data2 sheet) and it has values from 1-5. So the author created a pivot table and has a Row label in pivot table like this <tbody> Satisfaction on mangment very satisfied unsatisfied mixed very unsatified...