Forum Widgets
Latest Discussions
Formula Help Request
Currently works: formula: when entering a date (1/1/2025) into C1, D1 = date +2 years (1/1/2027) conditional formatting: when C1 "does not contain blank", C1 cell is green conditional formatting: when D1 "does not contain blank", D1 cell is red Problem: When C1 is blank, D1 shows "12/31/1901" and the cell is red My question: How do I keep D1 blank when C1 is blank but still adhere to the above formula + conditional formatting? Thank you.ksuttonMar 19, 2025Copper Contributor19Views0likes1CommentFILTER Function Help; Filtering on a column with a Formula
I'm attempting to use the FILTER function on a table in a different sheet. I've confirmed that the FILTER function doesn't need to be used in the same sheet containing the table. I'm assuming the issue is that the column uses a formula OR maybe the data type resulting from the formula. Sheet 1: Column E Formula is =C2=D2 Previous versions of Column E Formula were: - =EXACT(C2,D2) (Ran into case-sensitivity issue) - =IF(C2=D2, TRUE, FALSE) This column is confirming if the email in Column C (Current Email) & D (New Email) match. If not, then the user can easily identify which rows need to be updated. Sheet 3: =FILTER('1. Current FDM List'!A2:E166, '1. Current FDM List'!E2:E166=FALSE, ""). I also tried =FILTER('1. Current FDM List'!A2:E166, '1. Current FDM List'!E2:E166="FALSE", "") Both result in a #N/A error. Any help is appreciated. Note: I know I can manually filter Sheet 1 to show the rows with FALSE, but I'm attempting to have this tool do the work itself so it's as easy as possible for my team/ppl who aren't as excel savvy.4cmhMar 19, 2025Occasional Reader12Views0likes1CommentConditional formatting based on value in another range
I'm trying to format columns A, B, and C based on whether the value in column F is equal to 0. The conditional formatting rules shown result in rows doing just that (although only sometimes) but when the cell value in F is NOT 0 and never when the cell value is F IS 0. I don't know how to troubleshoot this. If you know why Excel displays this behavior, please respond in this thread. Thank you.SolvedPDX_GeorgeVMar 19, 2025Occasional Reader12Views0likes1CommentHow to allocate rows from one tab to another based off similar text?
Hi, Curious to know if there's a easier way to automate this process or if the only method is manual Basically, as seen in my attached sheet, i have tab 1 with a "masterlist" of brand petrol stations and their allocated coordinates. On tab 2, i have a list of special brand stations that i extracted from another source. I want to allocate each of the sites in 2 to 1 so they get their corresponding coordinates attached to them. Some of the names from 2 are the same as 1 so finding a match via vlookup is fine. However, some names have some differences e.g "Site Andy" in tab 2 is called "Site Andy Unmanned" and im assuming fuzzylookup is needed but unsure on how to allocate tab 1's coordinates to them. Additionally, i'm aware that some names on 2 might not exist on 1 so manual data entry/googling is needed which is fine. Just looking how to get the quickest way to allocate the corresponding coordinates to same/differently named but same sites and highlight the non-existing ones so i can manually find the coordinates. Thanks!james231660Mar 19, 2025Copper Contributor18Views0likes1CommentConditional Formatting based on cell contents and location
I'm really struggling here with some conditional formatting. Font colors in a range of cells need to change based on the cell above. For Example: Cells L48-Z48 contain a number, Cells L49-Z49 contain a number. I want each number in Row 49 to be red if they are greater than the corresponding number in the Row 48 cell above. L48=7 L49=7 - L49 font color should not change M48=6 M49=7 - M49 font should be red N48=7 N49=9 - N49 font should be red O48=6 O49=5 - O49 font color should not change It seems that I can only change the color of the range of cells based on a single target cell rather than the target cell being relative based on the formatted cell. Is there a way to do this that I am just completely missing, or do I have to Conditionally format each cell separately? I feel like I'm missing something so simple, either using "format only cells that contain "greater than"... or Using an IF formula.SolvedAxiomMBMar 19, 2025Occasional Reader18Views0likes1CommentAlternate to SUMIFS array assistance
Hello, everyone. I apologize for asking yet another SUMIFS question, but I haven't been able to find a thread anywhere (so far) that offers a sample similar to what I'm trying to do. I have a spreadsheet with 3 tables located in separate sheets: SKU, Production, and Expected. In the SKU table I have a list of item codes that are part of a general Category. In the Production table, I pretty much have a manual log of the number of Units that I produced in different Dates for each Item Code that applies. In the final table I pretty much just have a table with the Dates. The file I uploaded has a total of 4 columns in this table, but in my actual document the last 3 columns are actually arrays. I just placed them inside the table for purposes of this example. Anyhow, columns B-D are the Categories each Item Code belongs to: Blue, Green, or Red. What I'm trying to do is as follows: I'm trying to do the equivalent of a SUMIFs formula for Blue, Green, and Red. It first checks that the date in the Expected sheet matches the date in the Production sheet. Next, it checks in the SKU table which Category the Item Code belongs to for the selected date. It then adds the total Units for each Category column. I've tried with variations found online of SUMIFs and SUMPRODUCT, but I haven't been able to make them work. Any and all help is greatly appreciated.Eng_NoahMar 19, 2025Brass Contributor198Views0likes14CommentsExcel Help with setting formulas
Hello. I use a call log that is in the general program choices. Today I unintentionally made a change that made my dates / times / phone numbers formatting look different. The dates look don't look right, I had 03/18/2025 The start & end times looked like this 5:15 pm The phone numbers looked like this (509)231-9159 Please help! I have no idea what I did or how to fix it.MaryLGuinnMar 19, 2025Occasional Reader15Views0likes1CommentSlope equation calculation (Is it the same as trendline?)
Hi there, I'm trying to calibrate a temperature monitoring system in reference to a calibrated one. The relation is not linear, so the difference equation is not linear. This is where Excel comes in handy. I stuck both in water in the same environment at the same sampling frequency and generated a lot of points at a large temperature scale. Using a scatter chart, I generated a 4th-degree polynomial trendline that describes the relation between the both, with R2=0.9998. However, when using the equation to convert one value of one device to the equivalent in the other, the trendline equation throws random numbers at me, which makes me think that the trendline eq. and the slope eq. are not the same. I can share my date with anyone who is interested. Any idea on where I went wrong? Thanks!theDeCoder01Mar 19, 2025Copper Contributor53Views0likes7Commentsscaling graph paper
I would like to use Excel graph paper and make each square equal to 3/32 of an inch. How do i do this?Leon1730Mar 19, 2025Copper Contributor4.7KViews0likes3CommentsVlookup help
I have done the basic Vlookup to get data from one page to another, my Excel skill is just above beginner. I created this skill matrix and I was wondering if is possible to create a page where if i enter the name and last name of the employee ( we have some siblings and relatives so both conditions have to be meet) I will display all the Employees operations where there is a number and the number so it will look like the back of a baseball card. operations Last First Role MRP Setup Troubleshooting Inspection op1 op2 Filter name1 lastname1 machineoperator1 name2 lastname2 machineoperator2 2 name3 lastname3 machineoperator3 1 name4 lastname4 machineoperator4 name5 lastname5 machineoperator5 4 name6 lastname6 machineoperator6 1 name7 lastname7 machineoperator7 3 3 name8 lastname8 machineoperator8 1 3 name9 lastname9 machineoperator9 1 name10 lastname10 machineoperator10 2 3 3 name11 lastname11 machineoperator11 1 0 0 0 3 2 name12 lastname12 machineoperator12 name13 lastname13 machineoperator13 name14 lastname14 machineoperator14 something like this: name11 lastname11 Role: machineoperator11 MRP 1 Setup 0 Troubleshooting 0 Inspection 0 Thank you in advance for any guidanceLuchoarenas12Mar 19, 2025Copper Contributor89Views0likes6Comments
Resources
Tags
- excel42,403 Topics
- Formulas and Functions24,589 Topics
- Macros and VBA6,375 Topics
- office 3655,981 Topics
- Excel on Mac2,634 Topics
- BI & Data Analysis2,352 Topics
- Excel for web1,902 Topics
- Formulas & Functions1,716 Topics
- Need Help1,703 Topics
- Charting1,620 Topics