User Profile
Dtripple40
Copper Contributor
Joined Feb 17, 2021
User Widgets
Recent Discussions
Excel will not pull picture
So I am trying to reference a cell with a picture in it that way it pull the picture into another cell. I have watched about 6 videos on how to name the cell, then place the picture in the cell with the name. The picture is not outside the cell, the picture is in there. So when I type in =cellwithpicture I get 0. It is not pulling the picture from the cell. I have the capabilities of building the drop down menu and making my photos dynamic, BUT I CAN NOT GET EXCEL TO PULL THE PICTURE and I am getting very upset. Any help would be greatly greatly appreciated.2.2KViews0likes5CommentsSumifs problem
Hello, I have a data table full of information on certain people. I would like to be able to look up the date of of a name and a certain lifts. For example I want to be able to look up athletes A bench. So I would have athlete A in the drop down list, and bench, then it provide the bench for athlete A. Any help would be great. thank you!Solved2.2KViews0likes8Comments- 2.7KViews0likes2Comments
Re: Standard Deviation and Formula Look Up
oh man that is tough. thank you. that helped a lot. I should be able then to just paste function in for weight and date next to the subject as well correct? That should give me the subjects metrics on the correct date as well?HansVogelaar2.8KViews0likes7CommentsRe: Standard Deviation and Formula Look Up
Thank you!! That Was a big time help. If you are feeling really nice. I cant seem to get the subject name to look up by the date and name. I will end up having repeated subjects. Like two A's. So this weigh the book could look at the date and name and find the correct data for that day. SO for subject A on the 2/17 the correct data would come up. I have only come up with =if(c2=POWER[DATE]&B4=POWER[NAME],POWER[WEIGHT]..... I can not figure what would be next to have the book look up the name, date, then the metric associated with that name and date( HansVogelaar2.8KViews0likes1CommentRe: Standard Deviation and Formula Look Up
So I made it an array formula and now I am getting standard deviation values at 117 for the 2/16 when it should be 38. But I am also now getting values for 2/17 so that better. I added that [@Date] to see if would change anything. It did not. HansVogelaar2.9KViews0likes15CommentsStandard Deviation and Formula Look Up
Hello. I am having an Issue with my standard deviation not adjusting based off the date when looking up values. So the formula will not find the date in the table and update the averages based off the table. I have been struggling with this for a good few days and am beyond frustrated. Here is the book. Any suggestions or answered would be GREATLY appreciated. I plan on using the data on sheet 3 to create a pivot table and would like to compare the current subject selected the the average of the other subjects. So I am using the T-Scores to compare the subjects to each other.Solved3.2KViews0likes17Comments
Recent Blog Articles
No content to show