Hello all and thanks in advance for the help!
See attached file.
-B:B will be the date of the data capture.
-C:C will be the dollar amount of data.
-A:A is being used to determine if the data is within the last 12 months of the current entry(last row entry)
Columns O and P will be used to...
Hello all!
Thanks for the help. I have attached a file for reference with some comments...
Few things to note....
-Filtering is done so that it can be charted as two separate data blocks....
-Needs to be able to take more data than is posted, so the "blank data" on the end of the copied...
Hello all and thanks!
See attached for vision....
Have test scores from two different locations and would like to use the data for further analysis......
Possibly a macro but not sure if it is.......
Project has only two locations but many more charts in different locations on the sheet so an...
So in this line....
=IF('-700'!$A$10="Ebco",'-700'!$B$10," ") tests something just on a sheet named '-700'
I would like this line to be dynamic to look at the same cell on several different sheets....for example:
=IF('-700'!$A$10="Ebco",'-700'!$B$10," ")
=IF('-70'!$A$10="Ebco",'-70'!$B$10,"...
Hello all,
I have attached a file for reference......
Chart needs to have date on the left and a value on the right....
Will have "blank space" in between entries as shown......
Only values on the x axis will be the dates in the column, no blanks in between and no space, looks like here the...
Hello all and thanks in advance. File attached with the original layout and the desired final column.
-Original data will always be laid out as such with Date, sample1,sample2,sample3
-There will be blanks in the data that should be eliminated.
-Will be used later on in sheet for charting...
Hello all.....thanks in advance!!
Attached sample...
So I will have a list of Vendors (15 total) and various scores during evaluation periods.
I want to be able to just chart the specific vendor only across all time and then perhaps (maybe) a period of a year. I am using the NA() function as I...
Hello all,
I apologize if this was covered somewhere else and I failed to find it.
So on "MASTER" worksheet, I have 3 columns of data (A,B,C).....
Data will be filled out in cells A1, B1, C1 on "MASTER"
I need this data then to be entered on sheet "HISTORY", and have the value in A1 go to...
Hello!
I may have done this backwards, but hopefully I don't have to recreate much to save me time in this....
So I have D.V. lists that are filled with text each in a different cell...
10 pts = 100% of shipments on time
9 pts = 99.99% - 98% of shipments on time
8 pts = 97.99% - 95% of...
Basically I have data from a cell somewhere else and want to put it into my chart. Believe it may be called entering a "chart element" but don't quote me on that......
Text Box seems to not work as it enters text and not a formula.
If it is chart elements.....where do i find it?
Thanks for...
Here is an image for what I want the end chart to look like.
https://imageshack.com/i/p8D2admuj
I am having all kinds of issues on this and I believe (at least I think) it should be simple to make.
Right now, I have the data in two columns....
A column reads the 3 different kinds of fruit...
A B
Tom no
Bill no
Mike no
Joe no
Jim no
Matt no
Jerry no
If I want to search if Jerry is in Column A, then change its corresponding line to "yes".
Ex: Search Jerry, change it to yes. If I search Philip...
Hello forum, thanks in advance for the help.
I am using a table with different dollar amounts, both negative and positive in the same column. I understand that I can use the SUBTOTAL function to derive the sum of the numbers, however I would like to filter just the NEGATIVE numbers and make a...
I will have multiple users who will enter either 1,2,3,or 4 brackets.
Each bracket will have 8 positions, these will be determined randomally and are different sheets on the spreadsheet.
Ex:
Joe 4
Jerry 3
Matt 2
Mike 1
So Joe will have to get put in all 4 brackets...
Ok here is the file, hopefully this will show the interface requested.
Couple of things, I understand now (thanks to you guys) how the ISBLANK() function and how to return the "last" number of the list using the VLOOKUP() so I know how to clean up the ledger balance on each individual customer...
Sheet1 has categories A B C with subsets D E F respectively (ie. Fruit makes list apple, orange, and starberry/Vegetable makes list onion, potatoe,)
On Sheet2 I want to reference subgroups fruit and vegetable which are located on sheet1
What does the "source" area look like for that to...
I did a file in the past doing this with multiple tabs, one tab for each person involved and had a summary sheet for quick access but was not very dynamic and user friendly so i'm hoping there might be a better way...
I have X amount of people who have independent balances. These balances...
Example
A1: 5
A2: 6
A3: 9
A4: 2
Each of these values are out of a possible 10, so I would like the cell used to show the result to be able to count the "entries" and then return the correct percentage for the value against the total amount of the entries.
So above should be able to...
Hello
My 1st post.
I am pretty good at excel, but not good at macro programming.
Trying to create a spreadsheet with a couple of things going on so hopefully I will explain it well.
-Have a datatable with 6 columns and data in one of the columns repeats frequently
-Have several different...