User Profile
Ramiz_Assaf
Iron Contributor
Joined 6 years ago
User Widgets
Recent Discussions
Re: Need to calculate a Bell Type Curve Across a line of data
vsslasd Use a histogram. Then if your histogram has the bell-curve feature with a mean m and std of s then apply this formula on values that are 3s below your average to 3s over your average =norm.dist(x,m,s,0) see the example1.1KViews0likes0CommentsRe: How to use a keyword to input data for the whole row?
DruJackson You can do it using Vlookup from the name it will search vertically for the value you inputted "the name" and it will return another value "the description" or "the material" please see an example of the implementation2.2KViews0likes1CommentRe: Linked drop down menu
JoeWest I would create the list go to the cell you want to create the dropdown list and select data validation from the Data tab in the ribbon. Then in data validation select list and highlight the item names only. then in the cell next to it use the vlookup function, it will search for the inputted value from the drop down list in your table and report the correct value see the file951Views0likes1CommentRe: HELP! - I have no idea how to do it
ifiglus If you noticed each type of camera is a separate scatter plot. you can then decide if a scatter plot has lines or not if you want I can upload another example check this tutorial https://www.linkedin.com/pulse/scatter-plots-excel-data-labels-ramiz-assaf/?trackingId=q02KurJ2GX0BdddDs1UV%2BQ%3D%3D1.6KViews0likes1Comment- 954Views0likes0Comments
- 1.7KViews1like4Comments
Recent Blog Articles
No content to show