Recent content by Peter Quill

Hi, I am seeking assistance in establishing a proper and user-friendly format for arranging the monthly details report. Can you suggest me some key points or proper relevant articles?

Hello everyone, I want to be able to choose from three dropdown lists, and based on the selected options from each list, generate a corresponding result in another cell. While I've experimented with IFS and ORS formulas, they only seem to work for the first result option and not the other two...

Hello Everyone, I am attempting to solve a problem using solver that I built to complement a scenario that my students encountered while using a platform called knowledge matters. The long and short of it is that the students were tasked with figuring out the ticket prices for six sections in a...

Hello, I need to get missing values based on Sheet1, i.e. Data is in Shee1 but not in Sheet2. and duplicate from both sheets. The output will be in a new single result sheet with Date, item, and quantity (A, B, C ) columns i.e. Missing Value in Sheet2, Duplicate Values in both sheets. Please...

Yes, I was able to solve it using ChatGPT. Thank you.

Hello, Is there any way to compare text between 2 cells by ignoring if they are upper/lower case, punctuation, not in the same order, minimum 2 words same is okay. Please, see the below image. Thank you. Regards, Peter

Hello Everybody, I have a sheet (name : source) that fill with several small table, kindly help me how to copy each table to other sheets (name : template) and print it, and clear the table before next table copied to template, till the last table. Thank you for your help. Regards.

Hello Everyone, I'm having trouble overlaying data from both solar and usage data for electricity. The problem is that the solar data is measured in 15-minute intervals and the usage data is done by the hour. I have tried to organize the data according to that, but the problem is that the usage...

Yes, it was my first option. I am actually figuring out other options particularly this method to solve this issue.

Hello, Thanks all for your responses. Once I created a function in the Name Manager that looks like this =GET.CELL(63,INDIRECT("rc[-1]",FALSE)) this works but I don't know how it works but it does, it just doesn't update. So I found this macro that looks like this: Function ColorIn(color As...

Hello, I just tried to utilize this function and it works great, The only problem is that if I change the color of a cell the function doesn't auto update. How can i get it to auto update? I've created a worksheet where I'm using color to indicate if the cost of an item has been paid. If cell...

OS: Windows 10

Dear All, Hope you all are fine. I have a task at hand that requires preparing a summary sheet in an appealing and visually appealing manner. I would greatly appreciate your kind support in helping me formalize the summary by utilizing the data provided in the attached document.

I am working in an ISOLATED local area network, where there is NO INTERNET connection with the outside world. The machines are on LAN. I need to make a simple mailing facility, where one user can send mail to other users on another machine. One machine may be used by more than one person at...

Thanks for your help & support. Can u please explain the Function block you made? When i try to change the range, it is giving me error. Moreover, it is possible to make the function dynamic (Means if i delete the row in range or add any new row in range, it will update the function itself)...