Hi all,
I am currently trying out this formula:
Copy of my formula: =if(A5=Left(A5;5)="Bob G"OR(A5=Left(A5;5)="George G");"This formula works!";"This formula does not work!")
Essentially, what I want to achieve is for my formula to return "This formula works!" if the value in cell A5 is...
Hi all,
I have this file that was converted from PDF to Excel.
I would really like to filter everything in column A by date
However, when I do it looks like this:
It filters down until row 687
The row looks like this:
I have no idea why it stops?
It used to stop at points like these...
I feel like I'm going around in circles between index and more. I have multiple sheets, but for this example just set up the two I needed as they would appear in my workbook. I am trying to make it so that if I select a student's name from a drop down in Column A on sheet 'Student Report' (first...
Hello everyone,
I'm trying to extract data from sheet1 into sheet2. One of the columns in sheet1 contains a personal identifier along with other text.
On sheet2 I use a filter function to extract data from sheet 1 by referencing cells in sheet2 column (i) that lists the personal identifiers...
Hello
I'll try and keep this simple.
Sheet 1
This is a list of absence. Each separate occasion of absence is recorded against a unique employee ID in Column A and on it's own row.
On each occasion, there is an absence start date and an absence end date.
Example: an employee with 2 separate...
i am using this formula using lookup
=LOOKUP(2,1/(HHPPD[Code]=[@Code])/(HHPPD[SD]<=[@DOS])/(HHPPD[ED]>=[@DOS]),HHPPD[NP])
i want to use index match to rewrite the formula, i am trying following formula but it is resulting in #NA, whereas above mentioned formula is resulting in right value...
Hello,
I have a list of numbers in column A listed as Customer numbers, also in columns C,D,E are customer numbers. What I'm trying to do is if Column A info is found in column C,D or E, then Column F is Contacted, if not then not contacted.
Thanks in advance
I'm using excel 365
Hey people,
I'm currently working on a sheet containing thousands of entries where I will need to update information that is repeated throughout many sheets. Rather than manually 'Search & Replace', I was wondering if there was a way without doing (=A2), to have a formula that will associate...
Hello.
I've been using this forum for a decade and this is the first time I've needed to ask a question because there has always been an answer to my question.
Please help me figure out how to populate blank cells to the midpoint with the previous value i.e. I have semi random sample points...
Greetings All
I am out of ideas on how to implement a "FILTER" Func with Multiple Criteria for Office 2019 which does not support the function while Office 365 does. I have following example setup on O365 Excel and works like a charm.
I have (2) Workbooks - Workbook A [DCI Invoice.xlsx]...
I'm an Excel 365 user, and a very new one at that. Forgive me for my lack of etiquette within this forum, I hope that this first post may help introduce me to a way to solve this specific problem of mine, as well as to learn more about Excel 365 in general, and how to properly interact with this...
I have a data set with unique IDs in column B and dates in row 2. I am trying to make a formula that looks at a date I've selected, finds that column in the data sheet, looks at at a range that includes the found column and the 11 before it (i.e., a whole year), then counts the number of rows...
Hi all,
This may seem super simple and silly to ask, but I have currently made this setup:
I have hidden EVERYTHING except for rows and column 1-7.
However, I would like to unhide row 8-10 now, but I have no idea how? When I click on "7", which is the closest row I can currently touch, and...
bongbong marcos
excel
ez 16-0 guys
ez sverk
ez svork
ez win 16-0
ezz
ezz svork
ezzus sverkus
formula
haha ez win guys
help
hide
indexindexmatch
jonas sværke
match
sanoj ekrævs
unhide
vba
vlookup
Hi all,
I have this formula:
It pulls in data from here:
However,
despite this column being completely empty, it returns the value 0, rather than a blank cell as I have commanded it to.
I have checked the cells in column H and there are nothing there, not even a space, so i do not...
easy
excel
ezz
ezzus
ezzus sverkus
fast
formula
goldstrome
help
indexindexmatch
jonas sværke
match
p90 jonas svaerke
p90 rush svork
p90 svork
p90 svorkrush
sanoj ekrævs
svorkieboy
vba
vlookup
Hi all,
I have this very complex formula:
It returns a date value from a different sheet. However, it is returned in a number format, rather than a date format.
Any idea how to fix this? I believe that I can use the TEXT() formula, but I cannot figure out how :(
If anybody can help me...
date
easy
excel
ez sverk
ez svork
ezz
ezzus
ezzus sverkus
fast
formula
help
indexindexmatch
jonas sværke
match
sanoj ekrævs
sverk
sverkieboy
sverknation
sverktallica
svonkie
svorkie
svorkieboy
svorknation
svorktallica
svorkus
vba
A
B
C
D
E
F
G
H
1
week 1
week 1
week 2
week 2
week 3
week 3
2
W
R
W
R
W
R
WB
RB
3
25
10
30
8
30
12
30
FIND THIS NUMBER
I have a table of data that looks like above.
I have used MAX function to find the highest occurring number in cells labelled with "W".
In cell H3, I want to find...
Hi all,
I currently have this formula:
The formula is supposed to look at the values for the company (column B) and the topic (column F) and then based on the value in column F, it will look at the sheet with the same name and find the values here:
I likewise have a sheet with the same name...
Hello there - I keep forgetting how to think about the logic of these functions. I tried to look across my other workbooks for formulas. I feel like I've done this before so I apologize but I couldn't find the formula hence why I"m posting.
I've searched and using these links and posts as...
Hi guys,
I am currently working on a tool to efficiently print the logs of our production process. However, sad to say I am really stucked.
Initially, my idea was to be able to select the desired .xlsx file from a directory - which I was able to do using a macro.
Then...
Hi,
I am trying to make a column to obtain last values that were added in some table. Each month table expands so new values are added...
So far, I managed to get the way to obtain last value, last value -1 and last value -2 (so I'm having last 3 values in other words).
My problem comes when...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.