Most viewed questions in Others

0 votes
1 answer

Can not get bubble sort to run in excel's developer mode

Bubble Sort a Single-Column Range A Quick Fix Option ...READ MORE

Jan 30, 2023 in Others by narikkadan
• 63,600 points
348 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,000 points
345 views
0 votes
1 answer

Excel, AVERAGEIFS, Date discrepancy

When defining a range, you are unable ...READ MORE

Jan 22, 2023 in Others by narikkadan
• 63,600 points
344 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,040 points
344 views
0 votes
0 answers

pure component in react

What is a pure component in React ...READ MORE

Nov 6, 2023 in Others by Arya
• 990 points
343 views
0 votes
1 answer

Comparison operator with duration that may exceed 1 day with format h:mm

Try this: =IF(OR(AND(S2<=0.0417,D2="Imagerie Conventionnelle"), ...READ MORE

Mar 25, 2023 in Others by narikkadan
• 63,600 points
343 views
0 votes
0 answers

xcel VBA Chart counting and formatting

I want to develop a macro that ...READ MORE

Oct 31, 2022 in Others by Kithuzzz
• 38,000 points
343 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
342 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,000 points
339 views
0 votes
0 answers

What do Clustered and Non-Clustered index actually mean?

 I want to know about Clustered and Non clustered indexes. ...READ MORE

Jun 22, 2022 in Others by nisha
• 2,210 points
339 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
339 views
0 votes
0 answers

Two Backslash in SQL procedure with regular expression

On SQL procedure where i saw a Regular ...READ MORE

May 26, 2022 in Others by polo
• 1,480 points
339 views
0 votes
1 answer

Autofill macro to autofill dates up to 31 days regardless of the month

If you wish to utilise a single ...READ MORE

Feb 5, 2023 in Others by narikkadan
• 63,600 points
337 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,000 points
336 views
0 votes
1 answer

VBA Help on Splitting Worksheet

In this bit of code: ws1.Range("a:a").Copy Range("a:a") Intersect(.UsedRange, .Columns(i)).Copy ...READ MORE

Jan 19, 2023 in Others by narikkadan
• 63,600 points
336 views
0 votes
0 answers

Importing Excel files into R, xlsx or xls

Please can someone help me on the ...READ MORE

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

left join and left outer join?

What is the difference between LEFT JOIN ...READ MORE

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

Exclude worksheets from loop with a list

You can achieve this by making a ...READ MORE

Feb 11, 2023 in Others by Kithuzzz
• 38,000 points
334 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,690 points
334 views
0 votes
1 answer

Stuck on a Query for a stock trading spreadsheet

Try this: =QUERY(QUERY({QUERY('Movimentações'!A2:J,"Select F,C,D,E,(I*-1),(I*-1*J),(I*0),(J*0) where A matches 'Venda' ...READ MORE

Apr 1, 2023 in Others by narikkadan
• 63,600 points
333 views
0 votes
0 answers

How to set Bullet points colored in unordered and ordered lists in html via CSS without using any images or span tags

I want to differentiate the lists using ...READ MORE

May 26, 2022 in Others by Ashwini
• 5,430 points
331 views
0 votes
1 answer
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,600 points
329 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
329 views
0 votes
0 answers
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
322 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,000 points
322 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,600 points
317 views
0 votes
0 answers

locked textbox property set to true at worksheet

Hello, I have textboxes (activeX controls) on ...READ MORE

Oct 31, 2022 in Others by Kithuzzz
• 38,000 points
317 views
0 votes
0 answers

what is computer security system?

Mar 1 in Others by Priyanka
• 4,500 points
315 views
0 votes
0 answers

how to do hacking course?

Mar 1 in Others by Priyanka
• 4,500 points
314 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,000 points
310 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,040 points
308 views
0 votes
0 answers

which is better data science or artificial intelligence

Feb 1, 2022 in Others by Edureka
• 12,690 points
307 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,600 points
301 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
297 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,000 points
295 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
293 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
291 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
287 views
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,000 points
285 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,600 points
282 views
0 votes
0 answers

what is library automation ?

Jan 5 in Others by Evanjalin
• 6,710 points
262 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,040 points
254 views
0 votes
0 answers

what is automation engineering ?

Dec 6, 2023 in Others by Evanjalin
• 6,710 points
212 views