lots

Hi, Im wrangling a pivottable based off a single table. Its displayed in a tabular format. The table has property sale document number, price, sale date, buyer, seller, land description (e.g. Lot on Plan), certificate of title and I have got calculated fields for total area and, number of lots...

<tbody> Product Lot Exp A 1 X A 1 X A 2 Y A 2 Y </tbody> need function that will allow me to count different products with different lots from a list.

Hi everyone, I have a sheet that has lots of data in it. There are lots of row for the same company so i sort the sheet so all the company data from lots of rows is toghther. I like a macro that can insert a row in my data between the companies so i can easily see the companies data toghther...

Dear All, I have designed a report which contains lots of formulas including assay formula, every time when i save or fresh it takes 10 mins to recalculate so meanwhile i cannot do any other work from excel. Is it any other way we can work around it? At the moment I am using a different server...

I have a spreadsheet for attendance at a school. I want to be able to flag students who have missed the last 3 days of a class. So I want a formula that will look at the last three entries of a row and see if the last three cells all contain "A." If so I would I would like it to return 1. I...

I use Google Calendar with a script that counts up the revenue. I use Wave accounts to import bank transactions. I does 3 lots of tax including US, tax credits and UK self assessment. Please let me know if there is anything suitable? Thanks

hello this seems so simple but I can't work it out I want columns A to Z to display values by multiplying the percentages in columns AA to AZ by the corresponding row values in fixed column BA. e.g. A1 = AA1*BA1 B1 = AB1*BA1 C1 = AC1*BA1 Z1 = AZ1*BA1 A2 = AA2*BA2 B2 = AB2*BA2 A500 =...

Hi, I have a folder located at 'C:\Users\Steve\Desktop\2018 Data' and it has lots of subfolders and sub-sub folders. Throughout all the folders there are lots of .pptx files that I want to rename. The target files have a mixture of names but they all end in 'v1.0(A3)', eg. 'London v1.0(A3)'...

People I want D9 to grey if the value in D8 is anything other than "Other" I'm entering this formula into the use a formula function of Conditional Formatting =if($D$8<>"Other") And it's not having it. Please help. Lots of thanks

Hello, Can anyone please tell me what is wrong with this line of code. The aim is to determine if the field called Search_TB on a UserForm is blank or if whatever value is in that field is not in column 1 of a worksheet called ManSheet. If Search_TB = "" Or...

Hello everyone, I am glad to be here. I need some help with this table please. I have different lots made on different machines and the corresponding cells are marked x or y In G6 I need to find out which lot has the largest risk number and smallest potency. In H6 I need to find out which lot...

Hi, Can anyone suggest a formula or macro to sort a range of figures into a specified value? I have 30 figures or so, all between 1 and 3 and to 4 decimal places. I need to see how best to fit them into a number, ie the value 10 to get the minimum lots possible. Thank you

Hey Guys, I'm doing a Case Study for school on Excel, but our teacher didnt teach us this. What we have to do is list how many hours the worker has worked or underworked. For example, for Worker A as Worked 30 hours, but was expected to work 60 hours, he Under Worked 30 hours, so in the...