User Profile
laj_16
Copper Contributor
Joined Feb 16, 2023
User Widgets
Recent Discussions
tranferring data with the same id from different sheet
Good day I want to ask help with this problem. I have 2 sheets. The first one is where the original record is, while the sheet 2 is where the updating happen. What I want is whatever being input in the sheet2 column update is going to appear too in the update column in sheet 1 as long as they have the same ID. this is the sheet 1 this is the sheet 2another condition whenever the cell is blank
I'm having trouble with my project. I want to compute their weight status but I have 4 weight records. I have this problem that I wanna solve: if the 4th weight is blank then it will directly go to the 3rd weight same here if the 3rd is blank it will go to the 2nd and so on. Here is the code for my prediction here is my data where I compare my predictionCONDITION BEFORE INDEX AND MATCH
Hello I'm having a problem with my project. I would like to put a condition where if the gender is female then it will only output in the column of weight and height of the female and if the the gender is male then it will output in the column of weight and height of male. For this project I have 4 yellow columns which is the age, gender, height, and weight. If the input age match in any cell in first column then it will compare it height and weight status then output. After that I would like to put a condition base on their gender and just output their result on their respective column. this is my columns here's the code I'm using to compute the weight in age of girls :
