Search results

I am aware.....my sheets have changed since my original.....not sure what to do in this instance for forum purposes. But assistance on the attached file would be helpful....thanks!

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...

As requested.....here is the attached sample file....thanks for the help everyone!!

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...

Hi David, Thanks for the help! So is "Shippoints" the name of the table then? If I had 20 different questions, then perhaps 20 tables, one table to control each question?

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...

I found my solution so no help needed....thanks!

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...

Solid solution....how did you get those areas to "gray out"? I haven't seen that one before.... Thank you!!!!

Closer.... The "Legend" needs to be dynamic as this will grow with different types of fruit. The X Axis (tickmarks) need to change as well with the new fruit. List of different types of fruit will not be limitless.....will only be about 30 or so. Thanks for the help!

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...

Strange. It works when I click on the cell and "copy". It doesn't work if i click on the cell and type in the formula. Wonder why that is... Just a second thought HUI (Thanks again for your help as always). Can I make a D column to verify that the "yes" recorded correctly. I manually put...

having trouble with this and I don't know why.... HUI can you help? http://www.2shared.com/document/1MkqILty/jcalvaccasample.html This is the way the actual data is laid out and what I am trying to search.

Thanks and yes I should have mentioned 3 columns :-) This will make "yes" and "no" permanent? (i am not near the file or I would test it myself!)

Close, the big list is in column A, the "yes" and "no" list is in column B, and the list that i want to activate is in column C. So it needs to look at C, and see if the instance exists in A and then changes the corresponding data in B. Maybe just change it to...

looks impressive, but way too much information I believe. Basically i have a list of about 14000 items and I have a current list of about 4000 items. i want to "activate" the 4000 items on the list of 14000. I don't need drop down bars or the like. Thanks though for the help Swaroop.

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...

Thanks. However Im running Excel 2003. So now I think I'm back on the SUBTOTAL function?

Ok let me show an example... Jerry 65 Mike 17 Bill 22 Jerry 46 Mike -9 Jim 26 Mike -3 Jerry -10 If I want "Jerry" and sum of the negative numbers, this should return "10" If I want "Jerry" and sum of all the positive...

Not a table, its a list. Sorry about that. Can =-SUMIF(B2:B8,"<0") this be used with the subtotal function on filtered data? This would be perfect if it was a true range, but with the list it "appears" as a true range but the cells are are not.

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...

This looks like its good. Any chance you can get this to work on an earlier version of Excel? The laptop I'm thinking of putting this on has an earlier version of excel. Thanks for your help!

Thanks Hui. U are amazing at this stuff.

I suppose this operation would be difficult to put in because of the randomness of the numbers as well as not knowing how many participants there would be. FOr this to be effective, it would have to cover at least 20 players

Thanks again. Any help in dealing with the 9th competitor and more?