entries

Hi, I am trying to create a formula that will return the average of specific columns from the last x rows *matching* specific criteria. For example: https://i.imgur.com/MR2BSbL.jpg The formula would need to return the average WR (column I) for the last x entries for Deck (column D) - "Meta...

I'm trying to create VBA code (or functions if possible) that will identify all matching entries in column A and then total the values in a range from columns B through E from the rows with the matching entries, and then continue on to the next set of matching entries in column A. For...

Hi all, I need to be able to count the number of "yes" entries in a cell based on whether another cell contains a specific text. Here's my scenario: I have a tab called raw data that contains columns called: ID#, Title, Internal, Name, Location, Unit I want to count the number of "yes"...

This doesn't appear to be a new subject, but the solutions I've found don't seem to work for me. I have a range of approximately 200 unique alphanumeric entries in column A. I have new entries in column B and want to verify if there are any matching entries in column A. The formula isn't a...

I have hundreds of rows that contain a date stored in text format and a name, it's a holiday reconciliation report. I want to count the number of entries there are for each month and then also the number of entries for each person. I've been trying to use something similar to this...

Hi –once again looking for help….. I havea speadsheet which records various information…however I need to show the mostcommon text entries in column c (which has a dropdown list ) AND where column a= SST Is thispossible?

Hello, I currently have the following code to calculate howmany entries there are for each employee with in the date range (daterng2 &daterng3). I have now been asked to add an additional column which willbe cells(I,7) detailing how many unique months those entries fall under. Ie 01/01/2018...

Igrateful for any help here – way out of my depth. I have spreadsheet which has dependant drop downs using the indirect function. However,on the same sheet I need to record the 10 most often recorded entries in columnD Is thispossible?

Good morning all, This is my first post here and I am far from being an Excel guru so please excuse my ignorance. With that said, the problem I'm having is: I have a 2 sheet workbook, SHEET1 is daily sales and SHEET2 is year to date (YTD). Sheet 1 carries over to sheet 2. At the end of every...

I have two words in one cell in the data table, for example "apple pear" which have been concatenated from previous cells (in some cases I might have up to 6 entries) but in the pivot it shows as 1 entry. I need apple & pear to be 2 single entries in the pivot table. What can I put in the...

I have column A with entries and column B where some rows have the value "J". I want to create a data validation drop down list formula which only shows entries in column A which have the value "J" in column B. Can't figure it out... any help please? many thanks

I have problem with the following code. I am trying to copy data from one sheet "rp" and paste it into "peim" provided the if conditions is met. The code runs fine except it copy paste over the same cells in the destination sheet. So there are about 6 entries in the source sheet and i want all...

I am trying to generate random time entries Between two time limits in Excel. the problem i am facing is the generation works fine with the same day time calculation as soon as the time passes midnight, Excel gets confused and give me wrong values values. I need to generate random entries then...

Hi, I am adding to my sheet a trading simulator. Out of 100 trades, the Win Rate, for example, is 60% (60 trades will Win out of 100). On the spreadsheet, I want the R-Multiple colum to reflect this by showing 60 (3.00) and 40 (-1.00). Each Win is represented by a ‘3’ and each loss by ‘-1.00'. I...

I have a formula: =vlookup (park!$R$1&BI3,rtzca,2) When I copy the formula down 10 rows, it will duplicate entries if rtzca had no more data to show. So, first 5 rows will be fine then rows 6-10 will show same exact data as row 5. Then I have to delete those duplicate rows. How do I stop that...

Hi all, I would like to restrict decimal entries in a spreadsheet to be whole or half. For example 5.5, 7.5, 9.5, 22.5 is ok, but 5.1, 7.7, 9.4 ,22.6 etc. is not. Is that possible with formula? The ranges of cells would be D4:D81,F4:F81, I4:I81, L4:L81 Thank you!

Hey again all!! As always you guys/gals are the greatest!! I found a neat formula in an array, Tested it as it was setup and works great. When i go to modify it I get 3 results and boom it stops dead well rather it returns a blank as instructed. Table: Group Header: Group Entries: Fox, Bear...

New to this. Document was not created by me. Document has tabs at the bottom tab 1 is the master spreadsheet and it pulls data from tab 2. Tab 2 gets its data from a Sharepoint site. Doing Cnrtl-Alt-F5 usually updates Tab 1 and tab 2. Tab 2 is updating, but tab 1 is not. There are...

I have a single column. If I enter this code into the validation, It does what I want. It constrains the entries so that they start with either "PCO-R0343-" or "DVCO-R0343-"...

I have a weather dataset of over 5000 entries. The entries have hourly recorded values for each day from 20th-Jan-2006 to 31st-Aug-2006. I have to separate every day by inserting three rows and in those rows i want three formulas which calculate avg, min, max for of the different parameters of...