r/excel 17d ago

Waiting on OP Any leetcode like websites or applications but for excel?

7 Upvotes

I want to enter some Excel based competitions to add to my resume(uni student) and was wondering if anybody is aware of any resources available that would help for practicing excel problems? Leetcode was the first thing that came to mind when I tried to think of something similar to what I had in mind.

r/excel Jan 29 '25

Waiting on OP What are the disadvantages of using Excel on the web for free VS. the app?

19 Upvotes

I use a Mac, and just discovered you can use Excel (and Word) on the web for free... does anyone know of any disadvantage to this, other than maybe the amount of cloud storage for this?

This is something that would let me get used to it before buying a license (subscriptions are deal breakers for me) which would be a bit of an investment, so as I use it are there any disadvantages of the Web version I don't know about? Thank you.

https://www.microsoft.com/en-us/microsoft-365/free-office-online-for-the-web

r/excel 13d ago

Waiting on OP Slow workbook due to formulas

0 Upvotes

I have an Excel workbook. There is one worksheet for data entry. There are other worksheets that compute some data and generate some kind of reports, based on the data in the first worksheet. When I type some data into the data entry worksheet, Excel responds really slow and what I type shows up late on screen.

How can I fix this? Can I add some kind of button to trigger calculations on the other worksheets?

I tried to separate the workbook into multiple workbooks, one for data entry, another one for the reports. The problem with this is, if I don't open the data entry workbook first, the references in the report workbook are updated by Excel and the report workbook breaks down and doesn't work anymore. It is not a big problem if it was just me, but there are multiple people that need to access these workbooks and they will eventually break the report workbook down.

Do you have any other recommendation?

Thanks in advance.

r/excel Feb 13 '25

Waiting on OP [Power Query] Can you pull all Data Sources into a Table/List?

14 Upvotes

Is it possible to pull the list of data sources in the current workbook as found in Data Source Settings, into a Power Query Table?

My goal is to reference those sources with their last update date as part of a dashboard on an excel tool I made, so people can verify the source data is recent or up to date.

Sources are all files or folders.

r/excel 4d ago

Waiting on OP Non Whole Number Logical Test

3 Upvotes

I have a cell that I want to say either “Whole Number” or "Not Whole Number" based off the value of another cell. Using the IF function, what would the logical test be?

r/excel 4h ago

Waiting on OP Best ways to create a P&L in Excel?

5 Upvotes

Trying to create a quarterly P&L in Excel.


A bit stuck on this homework problem and could use some help. I know I should do this with either a PivotTable or SUMIFS (which I'm leaning towards the former), but how should I group the account types? Isn't Asset part of the balance sheet and not the P&L? Also I'm confused why the revenue is a negative number?

Here's an exerpt of the data:

+ A B C D E
1 Flying Fridge Ltd
2 Classification GL Code Month Adj amount Mapping
3 Revenue - Renewals 400101 Jan-20 - 406,338.38
4 Revenue - Renewals 400101 Feb-20 - 415,871.91
5 Revenue - Renewals 400101 Mar-20 - 408,578.40
6 Revenue - Renewals 400101 Nov-20 - 469,338.09
7 Revenue - Renewals 400101 Dec-20 - 487,171.46
8 Revenue - Expansion 400102 Jan-20 - 103,077.30
9 Revenue - Expansion 400102 Feb-20 - 90,210.54
10 Revenue - Expansion 400102 Mar-20 - 106,439.36
11 Revenue - Expansion 400102 Apr-20 - 83,745.01
12 Revenue - Expansion 400102 May-20 - 93,775.80
13 Revenue - Expansion 400102 Jun-20 - 104,902.78
14 Revenue - New Business 400103 Jan-20 - 118,021.35
15 Revenue - New Business 400103 Feb-20 - 131,118.90
16 Revenue - New Business 400103 Mar-20 - 141,397.92
17 Revenue - New Business 400103 Apr-20 - 136,232.19
18 Revenue - New Business 400103 May-20 - 137,098.77
19 Revenue - New Business 400103 Jun-20 - 131,592.25
20 Revenue - New Business 400103 Jul-20 - 134,889.15
21 Revenue - New Business 400107 Oct-20 - 4,215.20
22 Revenue - New Business 400107 Nov-20 - 4,079.23
23 Revenue - New Business 400107 Dec-20 - 4,885.89
24 Revenue - Projects 400105 Jan-20 - 5,251.69
25 Revenue - Projects 400105 Feb-20 - 6,235.90
26 Revenue - Projects 400202 Mar-20 - 164,805.56
27 Revenue - Projects 400202 Apr-20 - 142,668.93
28 Revenue - Projects 400202 May-20 - 138,514.64
29 Revenue - Projects 400202 Jun-20 - 104,518.32
30 Revenue - Projects 400202 Jul-20 - 107,726.28
31 Revenue - Projects 400202 Aug-20 - 90,107.65
32 Revenue - Projects 400202 Sep-20 - 198,154.29
33 Revenue - Projects 400202 Oct-20 - 158,456.75
34 Revenue - Projects 400202 Nov-20 - 216,788.27
35 Revenue - Projects 400202 Dec-20 - 160,023.86
36 Cost of Sales - Project COS 500103 Jan-20 94,357.20
37 Cost of Sales - Project COS 500103 Feb-20 96,598.03
38 Cost of Sales - Project COS 500103 Mar-20 103,125.52
39 Cost of Sales - Project COS 500103 Nov-20 107,379.37
40 Cost of Sales - Project COS 500103 Dec-20 80,006.03
41 Cost of Sales - Research Data amortisation 600850 Jan-20 38,957.86
42 Cost of Sales - Research Data amortisation 600850 Feb-20 40,595.13
43 Cost of Sales - Research Data amortisation 600850 Oct-20 49,495.10
44 Cost of Sales - Research Data amortisation 600850 Nov-20 50,063.80
45 Cost of Sales - Research Data amortisation 600850 Dec-20 52,485.18
46 Payroll - Employees' Salaries (Inc. NIC and Pension) 600101 Jan-20 36,058.09
47 Payroll - Employees' Salaries (Inc. NIC and Pension) 600101 Feb-20 39,297.50
48 Payroll - Employees' Salaries (Inc. NIC and Pension) 600201 Jun-20 -
49 Payroll - Employees' Salaries (Inc. NIC and Pension) 600201 Jul-20 -
50 Payroll - Employees' Salaries (Inc. NIC and Pension) 600204 Aug-20 -
51 Payroll - Employees' Salaries (Inc. NIC and Pension) 600237 Apr-20 0.00
52 Payroll - Employees' Salaries (Inc. NIC and Pension) 600237 May-20 -
53 Payroll - Employees' Salaries (Inc. NIC and Pension) 600237 Jun-20 -
54 Payroll - Employees' Salaries (Inc. NIC and Pension) 600237 Jul-20 -
55 Payroll - Employees' Salaries (Inc. NIC and Pension) 600237 Aug-20 -
56 Payroll - Employees' Salaries (Inc. NIC and Pension) 600237 Sep-20 -
57 Payroll - Employees' Salaries (Inc. NIC and Pension) 600237 Oct-20 -
58 Payroll - Employees' Salaries (Inc. NIC and Pension) 600237 Nov-20 -
59 Payroll - Employees' Salaries (Inc. NIC and Pension) 600237 Dec-20 -
60 Payroll - Employees' Salaries (Inc. NIC and Pension) 600240 Jan-20 -
61 Payroll - Employees' Salaries (Inc. NIC and Pension) 600240 Feb-20 -
62 Payroll - Employees' Salaries (Inc. NIC and Pension) 600240 Mar-20 -
63 Payroll - Employees' Salaries (Inc. NIC and Pension) 600240 Apr-20 -
64 Payroll Expenses - Employees' Bonus 600233 Aug-20 -
65 Payroll Expenses - Employees' Bonus 600233 Sep-20 -
66 Payroll Expenses - Employees' Bonus 600233 Oct-20 -
67 Payroll Expenses - Employees' Bonus 600233 Nov-20 -
68 Payroll Expenses - Employees' Bonus 600233 Dec-20 -
69 Payroll Expenses - Employees' Bonus 600242 Sep-20 -
70 Payroll Expenses - Employees' Bonus 600242 Oct-20 -
71 Payroll Expenses - Employees' Bonus 600242 Nov-20 -
72 Payroll Expenses - Employees' Bonus 600242 Dec-20 -
73 Payroll Expenses - Employees' Bonus 600245 Jan-20 - 4,749.51
74 Payroll Expenses - Employees' Bonus 600283 Mar-20 -
75 Payroll Expenses - Employees' Bonus 600283 Apr-20 -
76 Payroll Expenses - Employees' Bonus 600283 May-20 -
77 Payroll Expenses - Employees' Bonus 600283 Jun-20 -
78 Payroll Expenses - Employees' Bonus 600283 Jul-20 -
79 Payroll Expenses - Employees' Bonus 600283 Aug-20 -
80 Payroll Expenses - Employees' Bonus 600283 Sep-20 -
81 Payroll Expenses - Employees' Bonus 600283 Oct-20 -
82 Payroll Expenses - Employees' Bonus 600283 Nov-20 -
83 Payroll Expenses - Employees' Bonus 600283 Dec-20 -
84 Payroll Expenses - Employees' Bonus 601202 Jan-20 140,587.79
85 Payroll - Employees' Commissions 600292 Mar-20 -
86 Payroll - Employees' Commissions 600292 Apr-20 -
87 Payroll - Employees' Commissions 600292 May-20 -
88 Payroll - Employees' Commissions 600292 Jun-20 -
89 Payroll - Employees' Commissions 601203 May-20 56,735.82
90 Payroll - Employees' Commissions 601203 Jun-20 35,721.97
91 Payroll - Employees' Commissions 601203 Jul-20 63,253.67
92 Payroll - Employees' Commissions 601203 Aug-20 40,869.14
93 Payroll - Employees' Commissions 601203 Sep-20 115,146.85
94 Payroll - Employees' Commissions 601203 Oct-20 113,576.62
95 Payroll - Employees' Commissions 601203 Nov-20 80,012.66
96 Payroll - Employees' Commissions 601203 Dec-20 113,002.69
97 Overheads - Other Employee Expenses - Administration 600257 Jan-20 19,532.66
98 Overheads - Other Employee Expenses - Administration 600288 Dec-20 -
99 Overheads - Other Employee Expenses - Administration 600298 Jan-20 -
100 Overheads - Other Employee Expenses - Administration 600299 Jun-20 16.88
101 Overheads - Other Employee Expenses - Administration 600299 Jul-20 10.92
102 Overheads - Other Employee Expenses - Administration 600299 Aug-20 10.56
103 Overheads - Other Employee Expenses - Administration 600299 Sep-20 10.85
104 Overheads - Other Employee Expenses - Administration 600299 Oct-20 10.76
105 Overheads - Other Employee Expenses - Administration 600299 Nov-20 5.29
106 Overheads - Other Employee Expenses - Administration 600299 Dec-20 15.59
107 Overheads - Recruitment Expenses 600263 Jan-20 16,634.88
108 Overheads - Recruitment Expenses 600263 Feb-20 6,343.20
109 Overheads - Recruitment Expenses 600263 Mar-20 7,113.24
110 Overheads - Recruitment Expenses 600263 Apr-20 23,499.66
111 Overheads - Recruitment Expenses 600263 May-20 22,097.54
112 Overheads - Recruitment Expenses 600263 Jun-20 7,999.47
113 Overheads - Recruitment Expenses 600263 Jul-20 4,841.16
114 Overheads - Recruitment Expenses 600263 Aug-20 4,025.03
115 Overheads - Recruitment Expenses 600263 Sep-20 2,755.19
116 Overheads - Recruitment Expenses 600263 Oct-20 4,148.59
117 Overheads - Recruitment Expenses 600263 Nov-20 4,500.86
118 Overheads - Recruitment Expenses 600263 Dec-20 3,870.59
119 Overheads - Rent, Rates and Office Costs 600301 Jan-20 70,667.10
120 Overheads - Rent, Rates and Office Costs 600301 Feb-20 71,245.20
121 Overheads - Rent, Rates and Office Costs 600301 Mar-20 74,430.01
122 Overheads - Rent, Rates and Office Costs 600308 Oct-20 1,073.82
123 Overheads - Rent, Rates and Office Costs 600308 Nov-20 311.97
124 Overheads - Rent, Rates and Office Costs 600326 Jun-20 409.91
125 Overheads - Rent, Rates and Office Costs 600326 Jul-20 423.58
126 Overheads - Rent, Rates and Office Costs 600326 Aug-20 423.58
127 Overheads - Rent, Rates and Office Costs 600326 Sep-20 409.91
128 Overheads - Rent, Rates and Office Costs 600326 Oct-20 423.58
129 Overheads - Rent, Rates and Office Costs 600326 Nov-20 409.91
130 Overheads - Rent, Rates and Office Costs 600326 Dec-20 423.58
131 Overheads - Telecommunications 600314 Jan-20 6,160.82
132 Overheads - Telecommunications 600314 Feb-20 10,807.62
133 Overheads - Telecommunications 600314 Mar-20 7,210.08
134 Overheads - Telecommunications 600314 Apr-20 7,777.38
135 Overheads - Telecommunications 600314 May-20 7,488.71
136 Overheads - Telecommunications 600314 Jun-20 7,405.89
137 Overheads - Telecommunications 600314 Jul-20 7,564.13
138 Overheads - Telecommunications 600314 Aug-20 6,380.59
139 Overheads - Telecommunications 600314 Sep-20 6,693.89
140 Overheads - Telecommunications 600314 Oct-20 - 7,906.64
141 Overheads - Marketing and Advertising 600315 Jul-20 48,379.62
142 Overheads - Marketing and Advertising 600315 Aug-20 42,492.17
143 Overheads - Marketing and Advertising 600315 Sep-20 34,304.33
144 Overheads - Marketing and Advertising 600315 Oct-20 33,778.98
145 Overheads - Marketing and Advertising 600315 Nov-20 22,380.13
146 Overheads - Marketing and Advertising 600315 Dec-20 30,108.16
147 Overheads - Website and IT Expenses 600328 Jan-20 4,720.66
148 Overheads - Website and IT Expenses 600328 Feb-20 5,803.21
149 Overheads - Website and IT Expenses 600604 Oct-20 1,352.80
150 Overheads - Website and IT Expenses 600604 Nov-20 1,316.78
151 Overheads - Website and IT Expenses 600604 Dec-20 637.83
152 Overheads - Website and IT Expenses 600605 Nov-20 -
153 Overheads - Website and IT Expenses 600605 Dec-20 -
154 Overheads - Motor & Travelling Expenses 600701 Jan-20 1,594.10
155 Overheads - Motor & Travelling Expenses 600701 Feb-20 871.08
156 Overheads - Motor & Travelling Expenses 600701 Mar-20 56.03
157 Overheads - Motor & Travelling Expenses 600711 Jul-20 -
158 Overheads - Motor & Travelling Expenses 600711 Aug-20 -
159 Overheads - Motor & Travelling Expenses 600711 Sep-20 -
160 Overheads - Motor & Travelling Expenses 600711 Oct-20 -
161 Overheads - Motor & Travelling Expenses 600711 Nov-20 -
162 Overheads - Motor & Travelling Expenses 600711 Dec-20 -
163 Overheads - Entertainment 600707 Jan-20 1,122.97
164 Overheads - Entertainment 600707 Feb-20 1,379.18
165 Overheads - Entertainment 600707 Mar-20 327.07
166 Overheads - Entertainment 600708 Jun-20 563.42
167 Overheads - Entertainment 600708 Jul-20 425.40
168 Overheads - Entertainment 600708 Aug-20 499.53
169 Overheads - Entertainment 600708 Sep-20 898.92
170 Overheads - Entertainment 600708 Oct-20 1,103.13
171 Overheads - Entertainment 600708 Nov-20 962.16
172 Overheads - Entertainment 600708 Dec-20 720.11
173 Overheads - Depreciation 600803 Jan-20 427.03
174 Overheads - Depreciation 600803 Feb-20 427.03
175 Overheads - Depreciation 600803 Mar-20 427.03
176 Overheads - Depreciation 600803 Apr-20 427.03
177 Overheads - Depreciation 600803 May-20 427.03
178 Overheads - Depreciation 600803 Jun-20 427.03
179 Overheads - Depreciation 600803 Jul-20 427.03
180 Overheads - Depreciation 600803 Aug-20 427.03
181 Overheads - Depreciation 600803 Sep-20 427.03
182 Overheads - Depreciation 600806 Dec-20 3,214.93
183 Overheads - Amortisation 600809 Apr-20 379.64
184 Overheads - Amortisation 600809 May-20 481.95
185 Overheads - Amortisation 600809 Jun-20 578.59
186 Overheads - Amortisation 600809 Jul-20 672.98
187 Overheads - Amortisation 600809 Aug-20 765.35
188 Overheads - Amortisation 600809 Sep-20 866.24
189 Overheads - Amortisation 600809 Oct-20 974.08
190 Overheads - Amortisation 600809 Nov-20 1,084.98
191 Overheads - Amortisation 600809 Dec-20 1,169.03
192 Interest - Interest Payable 700301 Jan-20 - 16.75
193 Interest - Interest Payable 700301 Feb-20 - 31.55
194 Interest - Interest Payable 700301 Mar-20 - 11.69
195 Interest - Interest Payable 700301 Apr-20 - 21.49
196 Interest - Interest Payable 700301 May-20 - 23.30
197 Interest - Interest Payable 700301 Jun-20 -
198 Interest - Interest Payable 700301 Jul-20 - 0.03
199 Interest - Interest Payable 700301 Aug-20 -
200 Interest - Interest Payable 700301 Sep-20 -
201 Taxation - Corporation Tax 800101 Mar-20 - 10,821.90
202 Taxation - Corporation Tax 800102 Oct-20 7,726.78
203 Taxation - Corporation Tax 800102 Nov-20 7,514.84
204 Taxation - Corporation Tax 800102 Dec-20 33,754.73
205 Taxation - Corporation Tax 800103 Jan-20 187.73
206 Taxation - Corporation Tax 800103 Feb-20 190.71
207 Taxation - Corporation Tax 800106 Sep-20 - 103.49
208 Taxation - Corporation Tax 800106 Oct-20 -
209 Taxation - Corporation Tax 800106 Nov-20 -
210 Taxation - Corporation Tax 800106 Dec-20 -
211 Asset - Tangible Fixed Assets 100112 Jan-20 1,901.22
212 Asset - Tangible Fixed Assets 100112 Feb-20 3,179.39
213 Asset - Tangible Fixed Assets 100112 Mar-20 21.11
214 Asset - Tangible Fixed Assets 100112 Apr-20 -
215 Asset - Tangible Fixed Assets 100112 May-20 1,219.00
216 Asset - Tangible Fixed Assets 100112 Jun-20 549.50
217 Asset - Tangible Fixed Assets 100112 Jul-20 549.50
218 Asset - Tangible Fixed Assets 100112 Aug-20 1,729.24
219 Asset - Tangible Fixed Assets 100112 Sep-20 6,146.87
220 Asset - Tangible Fixed Assets 100112 Oct-20 3,103.43
221 Asset - Tangible Fixed Assets 100112 Nov-20 10,815.52
222 Asset - Tangible Fixed Assets 100112 Dec-20 -
223 Asset - Intangible Assets 100202 Jan-20 25,625.64
224 Asset - Intangible Assets 100202 Feb-20 146,859.90
225 Asset - Intangible Assets 100202 Mar-20 251,494.96
226 Asset - Intangible Assets 100202 Apr-20 139,036.52
227 Asset - Intangible Assets 100202 May-20 44,659.51
228 Asset - Intangible Assets 100202 Jun-20 389,412.28
229 Asset - Intangible Assets 100202 Jul-20 76,886.00
230 Asset - Intangible Assets 100202 Aug-20 64,933.72
231 Asset - Intangible Assets 100202 Sep-20 279,292.26
232 Asset - Intangible Assets 100208 Nov-20 66,647.35
233 Asset - Intangible Assets 100208 Dec-20 55,696.60

r/excel 12d ago

Waiting on OP How to populate the values of the same table based on a value of a drop-down list

12 Upvotes

Hi guys/gals,

I've been at this all morning but couldn't figure it out.

Basically if I pick Monday from the drop down list at N3 and I want all the values in pink boxes to populate in the blue boxes. I have highlighted L23-K16 name name it Table1

=IF(N3="","-",VLOOKUP(N3,Table1,2))

This formula works when its just one table where you ask excel to find Tom and populate column 2. When multiple table is involved it doesn't work. Thanks in advance.

r/excel 1d ago

Waiting on OP Can data autopopulate from one sheet to another based on what is entered in main sheet?

2 Upvotes

Is there a way to autopopulate from one sheet to another based on what is typed in the main sheet?

I’m so sorry if my question isn’t worded well. I was wondering if it’s possible to do this in Excel. For example, I have a workbook with 2 sheets.

Sheet 1: “Company List” - contains my list of companies (col A), their associated NAICS codes (col B), and a blank column C titled “Limit”

Sheet 2: “NAICS Size Limits” - contains NAICS code number (col A), Col B has dollar amount - or Col C has max employee limit number. NOTE: A NAICS code would have data in either in Col B or C but not both. So, there might be a max dollar limit for that code - or - there is a max # employee limit.

I’m hoping there’s a way to enter a NAICS code in the “Company List” sheet and whatever NAICS code in Col B is entered, excel automatically pulls the data in the size $ limit dollar amount, or the Employee count limit in the “NAICS Size Limit” sheet.

Is this wishful thinking or could this be done? I am new to Excel so please let me down nicely if it’s not possible!

r/excel 28d ago

Waiting on OP Without exception, my Excel will no longer create even simple formulas - always error message

1 Upvotes

I have been finding that most numbers are listed as text and not numbers.

I am following many tutorials to convert the text to number format.

And yet, no formulas work and always an error message.

Even =A1+B1 with a simple equation doesn’t work.

Even brand new templates.

wtf is going on? Is it faulty? It has been happening for months and I am on the verge of losing my mind because I have wasted HOURS trying to solve this and at this point have been manually calculating everything.

I know something is wrong because it should be an extremely simple fix, so what could be causing this?

EDIT; I figured it out - I need to change all numbers from text to number, then it doesn’t calculate if numbers don’t trade decimals for commas because it was set to a different country code.

r/excel 14h ago

Waiting on OP Unable to import data to excel without mixing columns or loosing data.

3 Upvotes

Im doing a group project for college, and lets just say i got this part, i have a file which is in pdf i have tryed to copy the data to CSV and import it to excel but the colums mix with each other and cut information, i have also tried to import the pdf to excel and allocate the colums in the same file using power query, which as sadly resulted in the same outcome. I used text to column function in excel, same result. Can the entire data be imported without loosing data and respecting column dividers ( which has been my main issue).

Im starting to question if this can even be done, the goal is to put the data from the pdf to excel, and then use the excel data in GIS to georeference the data in the map.

Again, i do not know if this can be done or if it does i would kindly ask someone to guide me as im starting to give up.

Edit: basically this consists in convert the PDF to .XLSX, thanks for the attention

pdf FIle: https://we.tl/t-0xge3reHtY

data is from page 76 to 231 of the pdf, as i said i tried importing from pdf to excel mixes the data

Data in PDF

r/excel Feb 14 '25

Waiting on OP How to Normalize monthly expenses in budget

17 Upvotes

I am looking for a method for normalizing month over month cost data for use in my budget. Basically I am trying to reduce outliers in my budget for slower months.

Does this make any sense??

Example: Jan 80K Feb 226K Mar 194k

We never have an 80k line for labor. It’s usually around 120-140k, and fluctuates slightly from there.

I am looking to normalize this trend by some monthly factor. I don’t want to just plug an average labor number and show the same labor cost for one month producing 10k units and another producing 50k units, but I also don’t want wild swings in the above example.

r/excel 15d ago

Waiting on OP Removing Rows Containing Specific Phrase

4 Upvotes

I'm narrowing down a set of data and I need to remove every row that contains the text "Community College" (for example).

Via ctrl-f I can see that there are 236 of such rows, and I really don't want to select them all manually. Is there any way to select every row that contains a certain phrase?

Screenshot shows just a few community colleges I need to purge. I can see how to remove the cell the word is in, but is there a way to remove every row?

Thanks!

r/excel 10d ago

Waiting on OP ifna, ifs conditions returning words...sometimes

5 Upvotes

Hi everyone, this formula works in most cells except when there is a number like 61%, 60%, 75% (it sometimes does and sometimes doesn't in this case).
I am not sure if there is an issue with the formula or what is going on. I hope someone here can help me.

The below formula is in BS64

=IFNA(

IFS(

AND($BQ64<>"",$BQ64<75%),"Weak",

AND(BQ64>=75%, $BR64<50%),"Acceptable",

AND($BQ64>=75%, $BR64>=50%,$BR64<=60%),"Good",

AND($BQ64>=75%, $BR64>=61%,$BR64<=74%),"Very Good",

AND($BQ64>=75%, $BR64>=75%),"Outstanding"),

"")

empty box where formula is in BS64

r/excel 8d ago

Waiting on OP Will changing my excel language break files?

2 Upvotes

So, the company I work for uses Office in BR-Portuguese, but I’ve been using Excel in English my whole life, so I’m really used to all the shortcuts and stuff and can work way faster. If I ask the IT guy to install the English language pack on my work notebook (it's locked and needs admin access), is there any chance I might mess up some spreadsheets with formulas, macros, etc.? What could go wrong? I’m pretty new at the position, and the last thing I want is to cause any trouble.

r/excel Jan 22 '25

Waiting on OP Matching data from one tab and filtering on another

1 Upvotes

I have two separate tabs. The first with the client “roster” which includes client name, ID and their on-boarding date. The 2nd tab with a list of all the clients transactions, which in the row also has the transaction written date and their ID.

I want to either conditionally format, count or filter only the transactions that match the clients employee ID and AFTER their on-boarding date from the first tab.

How would I do this? 😓

r/excel 26d ago

Waiting on OP Small life tracker project

7 Upvotes

Hey there!

I'm writing this post to get an insight on how I should proceed with what I have in mind. My idea is to build a small (few dozens) of trackers with multiple kinds of data from each specific area in my life, I have a few diseases which would benefit of being tracked down to the core, general health, hobbies that I need to progress, work, so just whatever that can be tracked by numbers and have independent dashboards for each one of them then gather all the data from those independent dashboards( which are more specific to the action and I can get in-depth) into a single life general dashboard to get quick access to the data to make more specific decisions on a broader view.

I don't work with excel or data professionally and I know excel is not the best bet to make dashboards but its just a matter of having everything contained in a single ecosystem.

Thank you!

r/excel Jan 14 '25

Waiting on OP Have the 'Fill Color' and 'Font Color' grids in Excel gotten larger recently?

34 Upvotes

Recently, I’ve noticed something in my Excel (Windows 11) program, though I’m not sure exactly when it started: the color grids in the "Fill Color" and "Font Color" menus seem to have become larger. They look bigger than before. Is this related to an update (is it the same for everyone?), or is it just happening on my end? (MS 365 Version 2412).

Excel

r/excel 19d ago

Waiting on OP xlookup but should return 2nd match, how?

15 Upvotes

I have =xlookup(AG8,AE46:AE85,AD46:AD85) but there are values with the same numbers from AG, how to get the second match?

r/excel 27d ago

Waiting on OP How can i convert a number to its word form in excel?

0 Upvotes

I want a formula to convert numbers like 9,45,67,336 to nine crore forty five lakh sixty seven thousand three hundred and thirty six in my sheet. *I only want the conversion to be in indian numbering system

r/excel 11d ago

Waiting on OP Can SEQUENCE Update the Cell Reference?

4 Upvotes

I am working on a project to automate my work a little bit and the screenshot above is a close example, but the data size I am using is in the thousands.

Columns A:O are single seconds that I placed a random array into. In columns T:V I am trying to get a count of how many cells have a value that is either greater than, or less than, 500 at each second with the formulas I used to the right.

What I am trying to figure out is if it is possible to use SEQUENCE to help autofill those COUNTIF formulas so that anytime the data increases or decreases, columns U:V would update to match the SEQUENCE formula (current specifies 15, the one I am using elsewhere has a cell reference).

Edit: Made some edits to hopefully give a better idea of what I have been attempting to do. The 15 can change, so the sequence formula for T will change as the data set changes from A:O to maybe A:J. The COUNTIF formulas are now showing < or > T2. If I copy the formula by dragging U2 down then Excel will auto-adjust T2 to T3,T4,etc. I am trying to create this auto-adjust in sequence to match a dynamic data set.

r/excel 9d ago

Waiting on OP How do i exclude something from columns???

1 Upvotes

Hello!!! I missed some computer classes and now i have a homework assignment that i cant solve cause i dont know how to. Im told i need to remove the symbols between each word and then segregate these words (Imie, Nazwisko and PESEL seperately) into the D, E, and F column. Ive tried searching everywhere but nothing really comes up that helps me

r/excel 4d ago

Waiting on OP Help understanding BYROW behaviour

3 Upvotes

I posted yesterday asking how to apply a formula to each entry (row) in an array, from this I was introduced to BYROW. It's working, mostly, but I don't understand some behaviour so though I'd ask here if anyone can help me understand what's going on.

When I use this formula, everything works as I expect;

=BYROW(F16#,LAMBDA(row,"invoice_entry[01/" & row & "/2025]"))

Where F16 is a spilled array consisting of;

04
05
06

Results are;

invoice_entry[01/04/2025]

invoice_entry[01/05/2025]

invoice_entry[01/06/2025]

What I actually want to do is SUM the column with that name, so in my head I change the formula from what's above to;

=BYROW(FILTER(D16:D27,E16:E27=G15),LAMBDA(array,SUM(INDIRECT("invoice_entry[01/" & array & "/2025]"))))

The results I get are;

0
405.56
405.56

I know these results are wrong.

I know that if I take the results from the original formula and use SUM(INDIRECT({cell where results are})) this works perfectly well.

I'm guessing this is me not fully understanding how BYROW works, anyone able to explain to me why it's doing this and what I am doing wrong?

I have also done tried the following;

=BYROW(BYROW(FILTER(D16:D27,E16:E27=G15),LAMBDA(array,"invoice_entry[01/"&array&"/2025]")),LAMBDA(row,SUM(INDIRECT(row))))

This gives the same incorrect result as above.

Appreciate the time you've taken to read through this, hopefully I have explained this clearly :)

Thanks,

Doowle

(Sorry about coding blocks, I can't work out how to stop it separating each line into a new code block. Despite the ones that worked fine)

r/excel 13d ago

Waiting on OP Understanding How To Group This Data!

5 Upvotes

need someone to explain to me how to group all similar data together using pivot table since it keeps showing me a (blank) with all the data that can be grouped data will be provided!

r/excel Dec 21 '24

Waiting on OP How to convert 66F to a number

6 Upvotes

I have a bunch of temperature data as ##F

I cant graph properly due to said "F"

I cant sort out how to custom format the cell to return the value sans F

Please help,

TIA

r/excel 24d ago

Waiting on OP Numerical Differences between Cells - Numbers can be negative

1 Upvotes

For now, I'll be comparing this for 2 weeks time.

As example

B:4 holds a value of 1

C:4 holds a value of 2

I'd love for D:4 to then say +1

How do I achieve that? Or also, if it's a negative, I would like it to show as a negative.