User Profile
Mitchyll2280
Copper Contributor
Joined Nov 03, 2022
User Widgets
Recent Discussions
Looking for a formula to help add values of a cell based on what is put in another cell.
Hello! I'm looking for some help figuring out a formula for excel.. I attached an excel file that details the problem. On the 'NDT Hours' sheet, there's an NDT column that contains a drop down list of various items. What I would like is when I select 'VT' from the drop down and enter a value in the adjacent cell in the 'Hours' column, I'd like it to add those hours to the cell adjacent of the cell labeled 'VT' in the 'Cover' sheet. I included some more information in the 'NDT Hours' sheet of the excel file that I hope will better explain what I'd like. If you have any questions, please let me know! Thank you for your time and help!Solved1.9KViews0likes3CommentsConditional Formatting Formula Help
Hello! I'm in need of some assistance. I want to have apply a formula that will highlight certain cells if they are greater than 0, but less than the value inputted in another cell. The user would input a value in cell AZ7. When the user types in a value in cell AG14 that is greater than 0 or less than the value in AZ7, then the row of cells (S14:AG14) would be highlighted. I've figured out with conditional formatting how to highlight AG14, but not the rest of the cells in that row. Any help would be greatly appreciated! Thank you!Solved953Views0likes2CommentsRe: Duplicating cell value on another sheet
OliverScheurich Thank you! So the formulas work and will add the cell values into sheet 1, but only into Row 14. What it's doing is only taking the first value greater than 0 and adding it to Row 14. If any other values are greater than 0, they do not show up in Sheet 1 unless I erase the first value. Is there a way to have them added to the rows below when I have multiple values above 0? Thank you for your help!2.8KViews0likes2CommentsDuplicating cell value on another sheet
Hello, I am pretty new to excel and this community. I have some knowledge of doing formulas, but all pretty basic. So, what I would like to do is this: If the value of cell "i2" in "sheet2" is greater than 0, then I would like that cell along with its description cell, "d2", to be duplicated on "sheet1", where the description would go in cell "a14", and value would go in cell "k14". Basically, once the document is finished, I'd like to be able to have any values greater than 0 on "sheet2" in row "i" to copy into row "k" of "sheet1" and would continue down as I add them (i.e., if 3 cells in column "i" had values greater than 0, then they would be inputted at "k14","k15", and "k16" and continue as such. The description cells would accompany those values as well, but would go in column "a". Thank you for any assistance or help! Please let me know if you have any questions or if this is even possible! Thank you!Solved3.1KViews0likes4Comments
Recent Blog Articles
No content to show