flat

i have attached an excel work sheet. It is about a building TOWER having 6 wings ABCDEF having each 22 floors . they have expenses and collection you have prepare some sheets on same file indicating 1)LIST OUT FLATS POSSESSION NOT YET DONE MEANS NOT SOLD. 2) FIND OUT FLAT WISE EXPENSE...

Hello, I'm trying to weight a score so that the closer it is to the top the smaller the increments are. For example, if someone scored 2.1 then they would get 100, if they get 2.5 then say 99, then 3.5 might be 96 etc. the further away you get from 2.5 the more severe the drop in score. When...

Hello Friends, I am in need of an index match formula with 2 criteria to match and return 1st Occurance than 2nd and so on Here is a sample data with headings in Row 1 Data starting from Row 2 (Coumns A,B,C) REF#------Name----------Size 414--------Flat Sheet-----125x200 414--------Flat...

Hi, I have a column with address details. I would like to separate the house number (always on the left) from the string. In some case, there might not be a house number, while in some other cases there might be a house and a flat number. I am only looking for the house number. Table below...

Hello and thanks in advance for any help. I'm trying to create a purchase sheet that includes a set up fee. The fee is either a percentage of the total or a flat fee of $130 whichever is greater. I have the formula calculating the percentage based on the subtotal [=15% * C1] but I want to...

Hello there, Hi Mick, Fluff and Rick ;-) I need help on a VBA code that could read a flat table and put the results in a 2D table. The 2D Tables has in rows a list of Animals that is always in the Flat Tables. (no more no less). The 2D Tables is NOT generated, it is the base where the flat...

I have a sheet with annual sales and would to show green, red or flat arrow to show if sales are greater, lese or equal to the previous year.

Hi, I have hierarchical data in a named range "Table1" that looks like below, where the "Count" is the value for each Category, and The "Cumulative Count" is the sum of the current level and all child levels. Is there a way to quickly get this into a format to use the Treemap or Sunburst plots...

Hi, I have a requirement for an excel sheet to be formatted from a flat structure to a stacked structure. I'll try to explain: In the flat structure has a number of basic columns, some of these columns repeat multiple times ('Transaction1', 'Transaction2', 'Transaction3'). some of the items will...

<tbody> A B C D E 1 0.000 FLAT 2 20.000 ROLLING 0.000 60 3 40.000 ROLLING 60 120 4 60.000 ROLLING 120 180 5 80.000 FLAT 6 100.000 FLAT 7 120.000 FLAT 8 140.000 ROLLING 9 160.000 ROLLING 10 180.000 ROLLING </tbody> I want to Lookup in Column B and...

I am looking to write some code that will take a flat file and create a child/parent hierarchy from it. The flat file is sorted in order so that each new row is either a new level in the heirarchy or a new child member. This is a sample of the sorted flat file from which the hierarch should be...

I have a workbook with multiple sheets, but am only concerned with the first two; Product Inputs and Outputs. Product Inputs includes information such as item identification numbers, dimensions, weights, etc. Outputs then takes those numbers and calculates profit, overhead, and quantity we...

Trying to provide a Quote sheet that lists the Materials,Grade of Materials, Raw Shape and Finish for a project. The Material selection can easily bedone through a Drop Down data validation list, but based on that selection I want the nextcell to only offer the Grades of Material associated to...

Hello Guys! Good day, I hope you all are doing fine, I need help this time for creating a payment schedule for loans on a flat rate with amortized payments, let´s put it this way <colgroup><col><col span="11"></colgroup><tbody> <tbody> A B C D F G H Payment Date Disbursed @ 6 Months @...

Hey all, I have been trying to create a formula to concat 7 cells in a row, skip blanks, and add some HTML tags to it. I know the formaula wont work below but I have put it back to basic and need help to get it to the next step. Details below...

Im looking to be able to select multiple input options from drop down boxes then see the changes these selected values have on other values selected by additional drop downs if that makes any sense. To reference a previous post on this issue: I now need to be able to add/compare additional...

I have a dataset with multiple layers where certain data points correlate to a single piece then that single piece correlates to multiple points. I am trying to flatten the data set so that all base items correlate to the final item in the total quantities. This is how the data is currently...

I have a workbook with a sheet set up as the user interface to a table of raw data on a hidden sheet. The user interface sheet has buttons to perform various actions on the selected "record" and to navigate back and forth within the records. The look of the standard MSForms and ActiveX Command...