DATE
How do I extract the date if the given data are: 1) Week ending date 2) Days of the week (for which the exact date falls into) See example below: …
Auto-change text to different text
So we are exporting data from FileMaker Pro. We have a column labeled as location and it will say something along the lines of: Tank II Rack 3 Slot 23. (There …
formula help
Please enter the excel formula if you need the cell to show “0” if 3 plus 4 equals and “1” 3 plus 4 is either greater than or less than …
Sum of n until m
Hello I want to formulate this [(n=0)∑(n=Ϻ-1) 1/n! (λ/μ)^n ] I’ve been browsing the net for half day and can’t find it. It …
HOW TO GET DESIRED OUTCOME USING EXCEL?
Hello, Don’t really know how to name this problem properly. Just made it more in a general sense rather than a specific one. Here’s the problem, …
Journal Entry Automation
I am wanting to create an automated General Ledger and Journal Entries. The way I am wanting to set this is up is having a list set up that a user can choose …
Calculation of combinations
Hi, I have an issue. Lets say I have 4 numbers (10, 50, 100, 250) and I want excel to give me the best combination of those numbers that will get me as …
Some assistance needed
Aoa, i am Uzma Razzaq from Islamabad Pakistan. i need a formula for excel sheet. As i have record of fee of school students. Condition: If more than one child …
Excel VBA master sheet copy-paste error 1004
Hello, I am new to VBA formulas in excel. I have a workbook with multiple sheets which needs to be copied(only values) in a master sheet in the same workbook. …
Which is the best function
I am using Excel 2016. I need to figure how to get the cell to calculate the total by adding specific amounts which are based on an index. For the …
Looking up text in string
Need to consolidate or look up which client deposited funds to our account. On our BANK DATA we see the account number or a reference from whom the transfer is …
Vacation Tracker earned days off based on years employed
I am needing help with the following I have spreadsheet that states employees hire date and formula to calculate that date to current date which auto generates …
Manipulate data in excel to order results per a certain column
Hi, I want to make the information in some columns (but not all) displaying in rows, please see below an example. This is what I have: …
Formula for If cell A2 is “text”, B2 = copy paste formula of B1
Hi, As written in the title, I want to copy past (similar to dragging down the formula) from a cell above if another specific cell contains a specific …
Work days with every working day displayed in a row
Hi everyone, I was wondering if someone could push me in the right direction regarding how to build a formula. I am looking for something to display …
How to keep same column but different row in formula when pasting in multiple cells?
I want to compare row and column values. My formula is =IF(A2=B1,1,0) . Next below cell formula would be =IF(A3=B1,1,0) and so on. Meaning compare the value of …
Scanning sheet in excel
Hello, I am working in a retail store and need to audit my inventory. I need to scan barcode tag which in return gives item code size and color of …
Top 10 sales by customer
Good afternoon. I have a complex formula that I need to build and don’t know where to start with it. i have built an automated front sheet that looks …
Using the text of a cell range (array?) in VLOOKUP or MATCH formula
Hi, Firstly sorry if my Excel lingo is a bit off as I’m self taught in Excel. Okay so my problem is simple, say if I had the letters a,b,c,d,e in the …
Checkbox Question!
Hi guys, there’s one thing that I wanted to do but couldn’t find any similar case after hours of googling. Here’s the case I have a list of …
Auto Populate Some Info
Hi, I’m trying to find out if I can input a file name such as “file name_123456_2018_NI” into one cell and have just what is before the first …
If statement between times and days
Hi everyone, I’m trying to create a formula for my overtime, as I get a different pay rate at different days and times. Mon – Fri: 17:00 – …
Record Date & Time on cell value change
Dear all Kindly solve one issue. My requirement is that when user enter some value in a10 cell, & z10 = a10, now if user assigns some value in a10 …
Breakdown of shift hours worked
Hey guys, I hope someone can help me with this. I’m trying to create a timetable to monitor my hours and what shift brackets they fall into but …
Excel Formula need to extract the number in a position
Latency: 0 1 0 1 1 0 0 277 290 267 212 214 0 290 …
Time formula
I’m trying to create a formula for time but having no success. I’m trying to create a sheet where meal breaks are automaticvally deducted …
Adding Hours for Tech Support
I am currently having to track the time all my support members are spending on the phone. We are having them submit a form which then in return is …
how do i search jpgs from an excel sheet?
I have a file of 1000+ jpgs and a list in excel of 300 file names – how do i search and find the 300 images in the bigger file? do i do this via dir …
Conditional Formatting Excel 2016
I am creating an excel document to help make work easier; I work at a non-profit agency. We have multiple families we serve (over 50). For each family, we must …
Count items based on another column
Hello, I am trying to find an answer to this problem. I can see that there are answers to this on Google but I’m still finding it hard to …
Sum whole Row
Is there a simpler way to achieve =((Attendance!$C$3*Attendance!C5))+ …
comparing two collumns and inserting collumn when not matched
Comparing 2 collumns from 2 different groups having a empty collumn between the groups , each group containing 4 collumns, inserting the cell in every collumn …
results in a pop up when click a cell
Hi. I want to see the results in a pop up when click on a cell. For a example when clicking on a product to calculate the discounts of a certain customer and …
Unique drop down list option for each column
Hey, I am trying to make columns that have one unique option. First check this image: https://i.imgur.com/uxwX57G.png Like you can see there …
Formulas for burnup/burndown chart
I’m trying to create a burndown and burnup chart for my team. However, I’m a bit confused as to what formulas I should be using with the data I …
Creating a graph simulating severel values for “X”.
Hello, I am using Excel 2007 and having difficulty creating a graph that calculates the value “y” for several “x” values. Here is the …
Matrix and kilometers
Dear reader, The Matrix below shows the distances between different cities in Poland. I have a dataset with courier services where the recipient city and …
top 6 values in a table
Hello, I have a table of values with 7 columns and 3116 row. The table is full of numbers and I would like to find out what are the 10 most recurring numbers …
Excel fomula for “Table Summary”
I have a list of products in my excel sheet1 (A:A contains the product code, B:B contains the color of item) On sheet2, I would like to have a summary table …
How do I create alternate colours which do not get effected when I use a filter a-z on them?
Hi, I have used an excel template for my pipeline which has alternate 2x colours rows and that makes it easier to read between rows. I have added filters to …