All Questions
693
questions
1
vote
1
answer
778
views
Is it possible to link an entry in a filtered sheet to the master sheet, matched on a key variable? (Excel)
I am trying to link a column in a filtered sheet to another column in the master sheet using a key category (i.e., id). Below is the illustrated dataset:
[]
As shown above, I have the master sheet, ...
1
vote
2
answers
780
views
Converting positive number values to boolean TRUE in excel
I'm trying to sum up all the entries based on several specific conditions.
The goal is to count all entries that have a 'yes' ticked in them in cells J or K or L or M and have '1st' in H
This is the ...
0
votes
1
answer
688
views
Microsoft Excel- prioritizing based on two date columns
I have two due dates I have to look out for at work, and I want to have a priority column that assigns a critical, critical,high, medium, low , low priority if either of those dates are within -120 , ...
0
votes
1
answer
64
views
How to perform same operation on non concurrent excel cells
I am trying to perform the same operation on excel on a range of non-concurrent cells.
Let's say I have range C:C, within this range I need to perform this operation IF(ISNUMBER(C2),(C2*A2),(0)). How ...
0
votes
1
answer
97
views
Tried multiple IFS formula. None is working
So I have a column which has country names plus a few blanks.
So I want the formula to go by this :
IF the country name is "India" put it as India and if the country name is anything else ...
-1
votes
1
answer
815
views
Restarting excel serial number
I wants to add a auto serial number into my excel sheet which should restart from 1 automatically as soon as the text in the next column changed. For example I have column of subjects i.e English, ...
0
votes
0
answers
57
views
Combine then count combination of text in cells in a table
I have an attendance table that I need to verify every day. Every day different employees are billed on different projects, locations, and hours. Each has individual columns while the employees have ...
0
votes
1
answer
1k
views
Conditional Formatting not updating when referencing new data from another sheet
I have a sheet called 'Email' in which I reference cells from the sheet 'CL Upcoming'. What I am finding is that when I add new rows to the 'CL Upcoming' sheet that the new rows in the 'Email' sheet ...
0
votes
1
answer
284
views
Concatenate sequential column cells into row cells
I need to transpose the columns of data in this format:
Input.
A1
B1
C1
D1
E1
F1
A
W
1
2
3
B
X
1
2
C
Y
1
2
3
4
D
Z
1
2
3
Into this desired result:
Output.
A1
B1
A
W1
A
W2
A
W3
B
X1
B
X2
C
...
0
votes
1
answer
83
views
Excel: Count Weighed Cells
I've an excel-spreadsheet, which is my timetable. this means, that I've some tasks, which is almost always a connected cell, sometimes I connect 20 cells, sometimes only two. Example
Since every cell ...
0
votes
0
answers
279
views
If Cell Contains Text Then Copy to Another Sheet
I want to copy a collumn on to another excel sheet where the first cell starts with: "Not Found"
If a cell in the first collumns contains "Not Found" I want to display them ...
0
votes
2
answers
78
views
Compare two sheets in excel
I have two excel sheets:
-Sheet1 (Giant list)
C2: Application name
D2: Local Name
E2: Description
-Sheet2 (Less application and local names than in sheet2)
A1: Application name
A2: Local name
I want ...
0
votes
2
answers
43
views
Excel FIltering by multiple criterias
I'm am trying to filter a report by patients who have been seen 2021 but if the patient had visits in previous years too I want to exclude them from the report. (so if the patient has been seen in ...
1
vote
0
answers
57
views
Filtering Excel "files" that have unique values less than a specific number provided in a column
I have 1000 excel files with the same format. Some of those files have multiple unique values in a specific column, whereas some has only 8 to 10. At this moment, i open every single excel file, then ...
0
votes
1
answer
236
views
Excel - sort one spreadsheet by exact order of second spreadsheet based on one column with same data
I trying to find a way how to sort one spreadsheet into the same order like second spreadsheet - based on their one same column for example.
Here's an example what i need, i will make more sense like ...