entries

Hi. I'm after some help with adding a formula to calculate a rolling average of the last 10 entries of a certain criteria. In column A I have five different locations. There are multiple entries for each location in the date order of measurements taken and column L has a measurement taken at...

Hi all, I have been supplied with a list of venue addresses, but it has been extracted from its source into excel all within column A! I need to extract certain information into other columns (name, postcode) but ideally don't want to trawl through thousands of entries and remove the lines...

I have a sheet which hold job information and hours for several different employees for each month. Each job has its own code so for example there may be 10 separate entries that have job code A10. Is it possible to create a list on a separate page that automatically copies across the job codes...

I have an advanced filter & based on the filtered information entries needs to be manually added eg based on a value per customer a comment next to it. However the information manually entered must not be lost / misaligned every time the filter is updated Is Avanced filter still the best...

I want it to take the difference of one 1 column minus a certain box and add together only 1 unique value since theres multiples of the same entry. I had SUM(E8:E50)-L4 Which worked until column E had several entries with the same value. Then it added column E together so the number was...

I have a sheet where multiple people add tickets every day I am trying to count the number of entries made by each person on each day Co column I has the person who created the entry and column O has the date, any ideas?

Hello, I have values in column A and dates in column B. How can I count the new entries today? What I mean is count the ones that occur today that haven't been entered before. Thank you for your help, XJ

Hey everyone, I've been struggling with a problem and can't seem to come up with a solution so I'm hoping someone here knows a quick fix. My goal is to use the advanced filter to remove duplicates from column H - MRColLetter - and paste it into the MRTable I've got on another worksheet. The...

Hi guys, i really need this. I am thinking about more than a month but i can't get it! I have values (serial numbers) in different dates, i will send a picture for better understanding. I need to calculate the serial numbers which is new, the values that weren't yesterday in my sheet but it is...

Hi I have a dynamic chart showing the last 90 days' entries and there are one or two spikes in the data that I want to comment on. Right now, the text box I added is fixed to where I inserted it in the chart so when the next entry is added it's out of position and therefore meaningless. Is it...

thought it might be easier to provide the basic idea with code rather than try to explain it. I am trying to take one record from "Entries" and paste into the "basic" worksheet, print the sheet (one per record , then clear contents for the next record to be copied and printed. End the end I...

Hi, I have a table with several columns and rows, is there a method to highlight the cell at the botom of the column in red if there are more than 2 data entries in that column? Thanks <tbody> A B C D E F J H I X X X X X X X X X X X X X X X X...

At one of our facilities they desire to use Excel as an electronic version of a Log Book. The idea is instead of hand writing everything in a ledger, they would enter it into a spreadsheet. This would give us the ability to sort and report on entries based on date, day of week, key words...

I'd like to sort my data (A1:D10 with headers) by values in column B. I want to only show entries that do not contain 123 or ABC or 456 or DEF in column B (entries can be at the start, middle or end therefore I'm guessing I'd need to use * wildcards). Autofilter seems to limited to two...

Please help, I'm trying to work an excel formula in order to report on a table of data. I’d like to return a "Yes" when unique entries in column A, when the corresponding range of entries in column B are unique. The data set is: Table1 <tbody> Column A Column B A 20 A 20 B 30...

Trying to count instances that meet the following criteria: =particular Month, =particular Doctor, =valid patient name. The column with patient name also contains entries such as "Off", "Out", "Break", etc. and these need to be NOT counted in this formula. (But need to stay in the source feed...

Hello all, I have what is hopefully a simple solution to solve. I have a sheet for staff to complete entries into columns A-G a single row at a time. In column H I have a check to make sure all entries are made and return a 1 if anything is missing. In column I u have the users email address. I...

I have a very basic table (two columns) with thousands of rows. Column A has a label, and column B has an entry. There can be multiple entries (rows) per label, but the number of entries per label will vary. (original table) Label A, Entry 1 Label A, Entry 2 Label B, Entry 1 Label C, Entry 1...

hello guys, I have a Worksheet_change code that is working perfectly well (see below). I would like to add another code, using the same functionality i.e. (Worksheet_change) so that all entries in column HA are automatically Uppercase. How can I add a second code, right after the one below so...

Hi, I am looking for a formula to count the amount of entries within C13:C512 There is a formula in each cell within this range which displays "" if nothing found I have tried =COUNTA(C13:C512) but this results in 500, even though there is only 44 entries displayed Many thanks for any help