group

In a Pivot Table if you put a numeric column in the row area, you can rt. click on any value in the row area, select "group" from the pop-up menu, and Excel will offer you the numeric grouping dialog that allows you to select from/to/step for numeric grouping. But, if you have even one error...

Hello,</SPAN></SPAN> Column "B" contains the codes, in the column "C" codes are grouped by in the friction of (1 to 2187) (2188 to 4374) and so on, numbers.</SPAN></SPAN> Example B4=100 are in the group from 1 to 2187, and the B5=3250 is in the group from 2188 to 4374 Note: to get these...

Hi I currently have data in Excel that I'd like to rank by group but also contains negative numbers and I would like negative numbers to be ranked higher than the 0 and above values. Here is the formula that I'm currently using - however it is ranking the negative value for group A as 1 and...

I have 'n' number of rows or lines with number values in various cellls across 'n' number of columns that I would like to group into 'n' grouping sizes. In the example spreadsheet I may have 6 columns and 13 rows of numbers of either 35 or 45 numbers in the various rows and columns, there is...

The following macro groups files by folder and produces the desired output. However, it is very slow when it runs on a large directory, like 'My Pictures' with 30,000+ files. I suspect I don't need a double loop, or perhaps I can use an array, but I am fairly new to VBA, and not sure how to...

Morning, Have a horizontal table, with 216 columns inclusive, starting in N16. Each 18 column group represents 1 month (12 * 18 = 216) I need a formula to map column index number to it's month, e.g. 14 - 31 = Jan (1) 32 - 50 = Feb (2) ... 218 - 229 = Dec (12) So...

Hi all, I am facing issue for match and interpolation of values as below. I need exact value and intermediate values if i select temperature and material group. <colgroup><col><col><col><col><col><col span="9"></colgroup><tbody> <colgroup><col><col><col><col><col><col...

Hello all, I'm working on a spreadsheet where I have numerous pivots. Some pivots I'm able to group the date field, however there's one pivot that I'm unable to group the same date field I'm able to in other pivots. Does anyone know why this might be happening? I've tried creating a new pivot...

This bit of code does a great job of listing all folders and files in a directory to a sheet. Sub cmdList() Dim sPath AsString Dim fOut AsVariant Dim r AsInteger Dim Cell As Range With Application.FileDialog(msoFileDialogFolderPicker)'.Title = "Select directory"...

Hello, this is going to be a slightly long question. I will try to be as detailed as possible. I have a workbook with data, and column F contains a long string of text, which is essentially a description. Column E contains either one of two identifiers, "Main" or "Related". When a "Related"...

HI I have a data import where the dates have come across with general formatting and a pivot table will not allow me to group these. What's the best way please to convert to am actual date so that I can group by month etc? I have tried DATEVALUE and whilst I get back the number format of the...

Hi All, Thanks for opening this up. I have an export of survey findings like this. <tbody> A B C D E Average Group A Group B Group C Yes 50% 65% 46% 46% No 50% 35% 54% 54% </tbody> I would like to format this in a way that columns C-E are highlighting significant differences of more...

I have created a groupings of several userform objects. With VBA, how can I move that group of objects into a certain position of a userform frame? Some groups have upwards of 20 objects.

I have searhced a lot but have not found any vaible solution for this. I want to know if there is any macro for this I have a list of columns in sheet 1 like this Group a Group B 123 456 231 415 122 313 122 122 in Sheet 2, if cell A1 = "Group a"...

Dear all, I need help. I would like to group the rows if the value is zero. For example, if cell a10 has a value, and a15 has a value, then row 11 to row 14 have to be grouped as row 11 to row 14 values are zero. I have 2000 rows. Can anyone help me with this please? Thank you very much!

I am writing VBA code to refer to the group number in cell ("W5") of my worksheet. Instead of referring to ("Group 336") - I want to refer to the group using something along these lines: ("Group (Range("W5").Value)"): Dim wsh As Worksheet: Set wsh = ActiveSheet Dim shp As Shape: Set shp =...

i have a rather long routine that I would like to fire off during my lunch break. I will have the work book open, and I have added the necissary code to the workbook_open event Application.OnTime TimeValue("13:00:00"), "AFK UPDATE" However my PC is set to lock after a few minutes due to group...

I know this has been covered, and believe me, I've looked around, but I haven't found a solution yet. I am trying to figure out how to write a recursive function that will give every possible combination given a certain group size. So, if the array is {1,2,3,4,5} and the group size is 3, I...

Hello, I am trying to update when users change one or group of cells within a range when there is a space to replace with an underscore. It is working, however with a group a cells, perhaps like copy or control enter, the values only update after you click on each cell. Works okay when one...