Most viewed questions in Others

0 votes
1 answer

Merging duplicate cells into a new column with VBA

The requirement to pull the first Open ...READ MORE

Mar 23, 2023 in Others by narikkadan
 • 63,420 points • 192 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 • 192 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 • 192 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 • 192 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 • 192 views
0 votes
1 answer

Reshaping/Deduping long data to wide in R

Using pivot_wider and rename library(dplyr) library(tidyr) repl <- c("1st_transaction" = "type_1", "2nd_transaction" = ...READ MORE

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

Filter/Extract a text from excel sheet having similar values

ISNUMBER(SEARCH("Maria,",SUBSTITUTE(A1:A4,"]",",")))  shows TRUE if Maria is found and false if it would ...READ MORE

Jan 9, 2023 in Others by narikkadan
 • 63,420 points • 191 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,420 points • 191 views
0 votes
1 answer

How to assign assign condition using if statement and VLOOKUP?

You can use either XLOOKUP() or INDEX() with MATCH() Function. • Formula used in ...READ MORE

Mar 26, 2023 in Others by Kithuzzz
 • 38,010 points • 188 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,420 points • 188 views
0 votes
1 answer

Want to merge two column that contains mobile number into one based on the condition that mobile no should be 10 digits

In Excel 2013 this formula can be ...READ MORE

Jan 9, 2023 in Others by narikkadan
 • 63,420 points • 188 views
0 votes
0 answers

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

What if we don't want to type ...READ MORE

May 28, 2022 in Others by Sohail
 • 3,040 points • 187 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 • 186 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 • 186 views
0 votes
0 answers

What is automation in computer?

What is automation in computer? READ MORE

Feb 2 in Others by Hoor
 • 540 points • 185 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 • 184 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,420 points • 183 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 • 182 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,420 points • 182 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 • 182 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,420 points • 181 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 • 181 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 • 181 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 • 180 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,420 points • 180 views
0 votes
0 answers

which is better data science or artificial intelligence

Feb 1, 2022 in Others by Edureka
 • 12,690 points • 180 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 • 175 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 • 175 views
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,420 points • 174 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,420 points • 173 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 • 172 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 • 170 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 • 166 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 • 165 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 • 165 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 • 163 views
0 votes
0 answers

How to automate data entry in excel?

How to automate data entry in excel? READ MORE

Feb 2 in Others by Hoor
 • 540 points • 161 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,420 points • 157 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 • 150 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 • 150 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 • 149 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,420 points • 135 views
0 votes
0 answers

what is automation engineering ?

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

what is computer security system?

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

how to do hacking course?

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

what is library automation ?

Jan 5 in Others by Evanjalin
 • 360 points • 80 views
Page:

Most popular tags

"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.