Most viewed questions in Others

0 votes
0 answers

Excel: Remove Duplicates based on time condition

A 3 month rolling time condition is ...READ MORE

Nov 2, 2022 in Others by Kithuzzz
• 38,010 points
237 views
0 votes
0 answers

Static Pages vs. Dynamic Pages, Which is Better for SEO

which ones better for seo static or ...READ MORE

Feb 18, 2022 in Others by Kichu
• 19,050 points
237 views
0 votes
0 answers

Angular and SEO indexing

app.config(["$routeProvider", function($routeProvider) { $routeProvider .when("/", ...READ MORE

Feb 14, 2022 in Others by Kichu
• 19,050 points
237 views
0 votes
1 answer

Extracting info from hyperlink

This will offer you an example of ...READ MORE

Feb 2, 2023 in Others by narikkadan
• 63,720 points
236 views
0 votes
0 answers

Why is Excel not calculating the cube root as the cube root?

I think Excel treats exponents with recurring ...READ MORE

Nov 2, 2022 in Others by Kithuzzz
• 38,010 points
235 views
0 votes
1 answer

Want to create a chronological row # then reset based on font color

Use this function to test the font ...READ MORE

Feb 2, 2023 in Others by narikkadan
• 63,720 points
234 views
0 votes
0 answers

Excel 2010, how to keyboard shortcut to filter dropdown checkboxes?

how do I get to the filter ...READ MORE

Feb 10, 2022 in Others by Edureka
• 13,670 points
234 views
0 votes
1 answer

Choosing a random text value from a list

Try this: =CHOOSEROWS(FILTER(B2:B100,A2:A100=FALSE),RANDBETWEEN(1, ...READ MORE

Apr 3, 2023 in Others by narikkadan
• 63,720 points
233 views
0 votes
1 answer
0 votes
1 answer

Delete table rows if time in column is >07:45

add a formula in a hidden column ...READ MORE

Mar 20, 2023 in Others by narikkadan
• 63,720 points
231 views
0 votes
1 answer

Repercute value on other sheet with "auto-detect"

Try in K9: =INDEX(IFNA(VLOOKUP(C9:C; Sheet2!B:H; 7; 0))) READ MORE

Jan 29, 2023 in Others by narikkadan
• 63,720 points
231 views
0 votes
1 answer

Highlight closest cell value in a table

Conditional formatting will be used to highlight ...READ MORE

Feb 18, 2023 in Others by narikkadan
• 63,720 points
230 views
0 votes
1 answer

Non-exact Vlookup with multiple search criteria - Microsoft Excel

Use the array function: =INDEX(A$2:A$100,MATCH(9^99,SEARCH(B2,A$2:A$100)*SEARCH(C2,A$2:A$100))) This will work with Ctrl+Shift+Enter but not ...READ MORE

Dec 23, 2022 in Others by narikkadan
• 63,720 points
230 views
0 votes
0 answers

What is the shortcut key to delete sheet in Excel?

Could someone tell me what is the ...READ MORE

Sep 8, 2023 in Others by Satyawrat
• 460 points
229 views
0 votes
1 answer

How can I sum all the data in January example

Your error is because your formula is ...READ MORE

Mar 17, 2023 in Others by Kithuzzz
• 38,010 points
229 views
0 votes
1 answer

How to show a row in excel if there is a X

FILTER Function: "filters" a range of data ...READ MORE

Feb 2, 2023 in Others by narikkadan
• 63,720 points
229 views
0 votes
1 answer

Calculate 3 days back but skipping weekends

For Office 365, assuming the Date and Project A ranges are A2:A12 and C2:C12 respectively: =LET( ...READ MORE

Jan 23, 2023 in Others by narikkadan
• 63,720 points
228 views
0 votes
0 answers

get unique distinct items based on a condition and a date condition

hi could you help me sorry my ...READ MORE

Nov 23, 2021 in Others by adolpo
• 120 points
228 views
0 votes
0 answers

What is the extension of MS Excel?

Could someone tell me what is the ...READ MORE

Sep 8, 2023 in Others by Satyawrat
• 460 points
227 views
0 votes
0 answers

I have a problem hosting a project made in Next.js

I have Next.js project. When I connect ...READ MORE

Jan 27, 2023 in Others by Tejashwini
• 3,820 points
227 views
0 votes
1 answer

How to break area chart in excel

Add an extra row between your areas. READ MORE

Dec 17, 2022 in Others by narikkadan
• 63,720 points
226 views
0 votes
0 answers

Android does not provide any two step toggle button?

I look into some of the android ...READ MORE

Jun 7, 2022 in Others by polo
• 1,480 points
226 views
0 votes
1 answer

Application.Workbooks(V_WBNameOutPut).Activate alternative

You can capture the workbook when it's ...READ MORE

Feb 18, 2023 in Others by narikkadan
• 63,720 points
225 views
0 votes
1 answer

Asset Write off calculation Automation

How about this in O29: =LET(period, ...READ MORE

Feb 14, 2023 in Others by Kithuzzz
• 38,010 points
224 views
0 votes
0 answers

Creating a chart in Excel that ignores #N/A or blank cells

A dynamic data series will be used ...READ MORE

Nov 2, 2022 in Others by Kithuzzz
• 38,010 points
224 views
0 votes
1 answer

Tab creation failure using macro

Export By Name From Multiple Worksheets Option Explicit Sub ...READ MORE

Apr 2, 2023 in Others by Kithuzzz
• 38,010 points
223 views
0 votes
0 answers

What does %>% mean in R

I am following this example, the server.R, file is ...READ MORE

Jun 1, 2022 in Others by avinash
• 1,840 points
219 views
0 votes
0 answers

Shortcut to insert row in excel

What is the Excel shortcut for inserting ...READ MORE

Sep 7, 2023 in Others by anonymous
• 990 points
218 views
0 votes
1 answer

outputting a coloured excel file, python

If you already have an Excel workbook, ...READ MORE

Mar 17, 2023 in Others by Kithuzzz
• 38,010 points
218 views
0 votes
1 answer

Change sheet tab color depending on CountA function result

Try using the ws. prefix to set ...READ MORE

Mar 28, 2023 in Others by Kithuzzz
• 38,010 points
215 views
0 votes
0 answers

Do you use attach() or call variables by name or slicing?

Many beginner R books and guides begin ...READ MORE

Jun 13, 2022 in Others by Avinash
• 1,260 points
215 views
0 votes
0 answers

Understanding the result of modulo operator: %%

Just trying to understand how the %% ...READ MORE

Jun 2, 2022 in Others by avinash
• 1,840 points
215 views
0 votes
0 answers

How to drop all tables from a database with one SQL query?

drop all tables without typing name. Is ...READ MORE

Jun 7, 2022 in Others by polo
• 1,480 points
214 views
0 votes
1 answer

Microsoft Excel - slow to open

We used to have a bat file ...READ MORE

Mar 21, 2023 in Others by Kithuzzz
• 38,010 points
211 views
0 votes
0 answers

What is function in MS Excel?

What is function in MS Excel? READ MORE

Sep 7, 2023 in Others by anonymous
• 990 points
210 views
0 votes
0 answers

which is better data science or artificial intelligence

Feb 1, 2022 in Others by Edureka
• 12,690 points
208 views
0 votes
1 answer

For loop to add up areas of openings excluding certain rows keeps returning #VALUE! error?

I think this might be more of ...READ MORE

Apr 7, 2023 in Others by Kithuzzz
• 38,010 points
198 views
0 votes
1 answer

Excel - Find the Max for Total revenue just for year 1

In Office365 and LibreOffice Calc, there is ...READ MORE

Jan 8, 2023 in Others by narikkadan
• 63,720 points
198 views
0 votes
0 answers

Seo panel Google API verification fails

API verify connection fails when i am ...READ MORE

Feb 14, 2022 in Others by Kichu
• 19,050 points
198 views
0 votes
1 answer

Reference Excel sheet number in an external workbook

Try this: Function SheetByCodeName(wb As Workbook, cn As ...READ MORE

Mar 17, 2023 in Others by Kithuzzz
• 38,010 points
196 views
0 votes
0 answers

How to remove formula in excel shortcut

What is the Excel shortcut key for ...READ MORE

Sep 7, 2023 in Others by anonymous
• 990 points
192 views
0 votes
0 answers

what is computer security system?

Mar 1 in Others by Priyanka
• 700 points
190 views
0 votes
0 answers

Excel Formulas Limitations when compared to Excel VBA Power

I'm an Excel VBA programmer that had ...READ MORE

Mar 26, 2023 in Others by narikkadan
• 63,720 points
176 views
0 votes
0 answers

how to do hacking course?

Mar 1 in Others by Priyanka
• 700 points
171 views
0 votes
0 answers

what is automation engineering ?

Dec 6, 2023 in Others by Evanjalin
• 360 points
137 views
0 votes
0 answers

what is library automation ?

Jan 5 in Others by Evanjalin
• 360 points
124 views