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.
FILTER 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.Conditional 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.
How 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!
Alternate 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.
Excel 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.
Slope 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!
