Jopa, thank you so much for this wonderful training, I followed you to the letter with this formular, but i am having #VALUE! =IF(E13>D13,E13-D13,1-D13)+IF(G13>F13,G13-F13,1-F13+G13)
One more thing, how could I make the data entry separate from the database so it´s only "one-way": people feed but has not access to the information PLEASE?
This is great.....except......it doesn't seem to continue counting automatically. What I mean is, every time I put in a new entry in the coloured field, I then have to click on the count_colour function cell to bring up the edit panel and hit enter for the count to go up by one. Any ideas why that would be happening?
Around 18:16 min you said we should chose the F something key,i cant figure out what you are saying due to the accent and im stock there.please can you tell me the key you were refering to,will really appreciate it thank you
Can you make it so when you choose for example the rent option the expenses label auto populates? So like you skip entering it but its just there already?
Thanks, Jopa. A couple of thoughts: 1) your idea about first copying/pasting all values into the Form and then copying pasting them again on the Inventory sheet was new to me. However, I thought that whenever one selected "copy values", the formulas naturally wouldn't paste. I'll have to test this out to see what happens. 2) An alternate way to hide the helper cells is to make them all white 3) One should also protect the worksheets so that users can modify only certain cells. That is, the helper cells on the Form and the cells in Inventory should never be directly modified by users.
Thanks for the feedback! 🙏👍 About the number 2-). I actually did make it all white in the origianl video, but I removed this part when editing the video, the video was getting too long and I don't like to waste the viewers time, but anyway... About 3-). You're right, protecting the sheet is an excellent idea. I will bring more videos on the subject and I will definitely consider your feedback. Thanks a lot.
@@JopaExcel Hey. Thanks. Btw, re my first point, when I queried chatGPT 4.o about it, it said if you just select "paste values", the formulas (i.e. =cell) will not be pasted. So, what's the issue?
@@seymourtompkins It is possible to copy and paste cells with formulas. You don't just need to copy and paste only values. Just copy a cell that has a formula inside, and then use "Home tab" then "Insert", "Insert Cells" and "Shift cells down". It works, please test it and you will see.
@@JopaExcel You misunderstand me. In your video, you stated that you did NOT want to directly copy and paste into the spreadsheet for fear that would carry over formulae too (such as ' =A1 '). As you'll recall, that was why you first copied/pasted onto the original sheet before copy/pasting a second time into the spreadsheet. With my comment, I was just indicating that coying/pasting twice was unnecessary if you use 'copy values'. Get my point ?
I can't figure out the gradients, so I just did without them. However, my real problem is getting the percentages (only) to show up inside the colors on the circumfrene of th donut. It shows the legend, the actual value, and then the percentage.
I just have a question regarding the final graph, 6:51. When you have a small dataset, it is easy to figure out by “eye” the points of the graph or the period in which you have a correlation. Do you know if it is possible for Excel to provide you with the most correlated period? For example, in your dataset, can Excel indicate that between wk 3 and 4 was the best period (negative correlation)?
I have seen tons of videos and articles on sorting in Excel, but none meet my needs. I have a database of semiconductor parts such as transistors, ic, ettc. The alphanumeric variations in names are such that none of the sorts actuallly work for it, instead make it messier. An example of some of the name types are: 1N2902, 2n7656, DM74s678, MM74ls545, 74LS343, sn75054, NTE123, LM709, TC21, TMM6754, Z8353, etc. The numbers are all entered as text. Ideaally I could sort my the first lettter. Then second letter, third letter, and fourth letter. But, I would settle for being able to just sort 1 thro z if that is all I could do. Several so called “experts” can’t even understand why I need it, let alone tell me how. (Including 2 from Microst) I Despeartely need help, and appreciate any advice. Thank you.
