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...
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...
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...
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...
Hello,
I am attaching a file that has certain readings every hour daily. I want to find out how to calculate no of hours when
1. FT1003 (Column C in SO2 Sheet) value was increasing
2. FT1003 (Column C in SO2 Sheet) value was not increasing
3. P101 (Column D in SO2 Sheet) value was "TRUE"
4...
Private Sub TarikDataKoreksi()
Dim lr, lrow, i As Long
Application.ScreenUpdating = False
Application.EnableEvents = False
Application.Calculation = xlCalculationManual
Sheet_Name = "Form Faktur"
'to select folder contains workbooks
Set File_Dialog =...
I am Peter Quill. I work in HR at a multinational organization. I am here for your valuable opinions in Excel and to share my experiences as well. Thank you.