Sirs,

i have sheet 1, sheet 2 and merge..

i need to merge the data of sheet 1 and sheet 2 in which sheet 1 will be the main sheet and sheet 2 data will be inserted from sheet 1. the reference cell will be the names..

as you can see there are multiple names from sheet 2. how can we merge that sheet 1 will add an empty cell?.. thank you

https://docs.google.com/spreadsheets...it?usp=sharing

]]>i have sheet 1, sheet 2 and merge..

i need to merge the data of sheet 1 and sheet 2 in which sheet 1 will be the main sheet and sheet 2 data will be inserted from sheet 1. the reference cell will be the names..

as you can see there are multiple names from sheet 2. how can we merge that sheet 1 will add an empty cell?.. thank you

https://docs.google.com/spreadsheets...it?usp=sharing

Hi,

Is there a way to combine the Unique function with Googlefinance function? For example: I have =googlefinance(N7,"Name"), which returns the name in cell N7. However, I want it to use Unique so it doesn't return duplicate names. I have tried this, but it's not working.=Unique(GOOGLEFINANCE($N$6:$N,"Name",$N$6:$N))

]]>Is there a way to combine the Unique function with Googlefinance function? For example: I have =googlefinance(N7,"Name"), which returns the name in cell N7. However, I want it to use Unique so it doesn't return duplicate names. I have tried this, but it's not working.=Unique(GOOGLEFINANCE($N$6:$N,"Name",$N$6:$N))

hi,

In excel there is a Data type for Stocks. Is there anything like that in Google Docs? I like the way excel changes a ticker to the Stock Exchange and also you can click on it and it give real time data information. However, I'm using Google Sheets and do not see anywhere how to change Data type to Stocks. Pic below is just a reference as to what is in excel. Thank you.

Screenshot 2024-09-24 at 2.04.07 PM.png

]]>In excel there is a Data type for Stocks. Is there anything like that in Google Docs? I like the way excel changes a ticker to the Stock Exchange and also you can click on it and it give real time data information. However, I'm using Google Sheets and do not see anywhere how to change Data type to Stocks. Pic below is just a reference as to what is in excel. Thank you.

Screenshot 2024-09-24 at 2.04.07 PM.png

Hi,

How can I reference sheet name with indirect function.The sheet name is located at B2.So indirect (A2) with range mentioned in formula which is at A5.

Also,in formula I want to add Col4 =A2

MAX is the sheet name to be referenced.Formula is in 'Choose'

]]>How can I reference sheet name with indirect function.The sheet name is located at B2.So indirect (A2) with range mentioned in formula which is at A5.

Also,in formula I want to add Col4 =A2

MAX is the sheet name to be referenced.Formula is in 'Choose'

Code:

`LET(`

rawData, HSTACK(

MAX!A2:R,

INDEX(N(MAX!S2:AR)),

MAX!AS2:AS

),

mainQuery, "

SELECT

Col4, Col5, Col7, Col8, Col9, Col10, Col11, Col12, Col13, Col14, Col19, Col40,

SUM(Col22) + SUM(Col24),

SUM(Col23) + SUM(Col25),

SUM(Col33) + SUM(Col35),

SUM(Col36) + SUM(Col34),

Col41, Col42

WHERE

Col4 IS NOT NULL

GROUP BY

Col4, Col5, Col7, Col8, Col9, Col10, Col11, Col12, Col13, Col14, Col19, Col40, Col41, Col42

ORDER BY

Col4

LABEL

SUM(Col22) + SUM(Col24) '',

SUM(Col23) + SUM(Col25) '',

SUM(Col33) + SUM(Col35) '',

SUM(Col36) + SUM(Col34) ''

",

mainResult, QUERY(rawData, mainQuery, 0),

subQuery, "

SELECT

Col4,

SUM(Col19),

SUM(Col40),

SUM(Col22) + SUM(Col24),

SUM(Col23) + SUM(Col25),

SUM(Col33) + SUM(Col35),

SUM(Col36) + SUM(Col34),

SUM(Col41),

SUM(Col42)

WHERE

Col4 IS NOT NULL

GROUP BY

Col4

ORDER BY

Col4

LABEL

SUM(Col19) '',

SUM(Col40) '',

SUM(Col22) + SUM(Col24) '',

SUM(Col23) + SUM(Col25) '',

SUM(Col33) + SUM(Col35) '',

SUM(Col36) + SUM(Col34) '',

SUM(Col41) '',

SUM(Col42) ''

",

subTotalRows, QUERY(rawData, subQuery, 0),

subTotalLabel, MAP(

CHOOSECOLS(subTotalRows, 1),

LAMBDA(m, HSTACK(m, "Total " & m, SPLIT(REPT("~ ", 9), "~")))

),

subTotals, HSTACK(

subTotalLabel,

CHOOSECOLS(subTotalRows, SEQUENCE(1, 8, 2))

),

finalResult, QUERY(

VSTACK(

HSTACK(CHOOSECOLS(mainResult, 1), mainResult),

subTotals

),

"SELECT * WHERE Col1 <> '' ORDER BY Col1",

0

),

CHOOSECOLS(finalResult, SEQUENCE(1, 18, 2))

)

Hi,

I have a formula - "=sumproduct(--MONTH(Spreads!$S$5:$S)=12)".

This formula goes to the "Spreads" worksheet and looks for all instances that equal the month of Dec. However, right now, there are no instances, but it's returning the number of 984. I have this for Jan - Dec and the rest of the months appear to work fine, just dec is not correct. Thank you.

]]>I have a formula - "=sumproduct(--MONTH(Spreads!$S$5:$S)=12)".

This formula goes to the "Spreads" worksheet and looks for all instances that equal the month of Dec. However, right now, there are no instances, but it's returning the number of 984. I have this for Jan - Dec and the rest of the months appear to work fine, just dec is not correct. Thank you.

I have an idea and I want to apply it using google sheet

I have a group of students, each student has its code. I need that each student know its result after entering its code privately and individual manner.

is it possible to do that in Google sheet ?

Thx.

]]>I have a group of students, each student has its code. I need that each student know its result after entering its code privately and individual manner.

is it possible to do that in Google sheet ?

Thx.

Good morning,

I am trying to keep a running tally of a profit / loss tracker for daily stock stuff. Everything is fine up till I enter a Withdrawl or Add a contribution.

-Everyday I go in and enter today's date along with the value of the account (Daily Start Net Liq), which is column B. If column B is greater than yesterdays column D, then the difference is profit. However, if I enter a withdrawal or a contribution the Profit and loss column is not accurate. The profit and loss in cell E3 is accurate, but from there on out it is not accurate. Below are the formula's currently used. Hope this helps explain.

Column D formula -=if(ISBLANK(B9),"",(C9+D9))

Column E Formula -=if(isblank(B10),"",abs(C10-E9-(sum($D$7:D10))))

If I add something in the withdrawal or contributions column I want to still be able to see my overall Profit and Loss, if that makes sense. Here is a screenshot of the table. Thank you.

Screenshot 2024-09-21 at 9.56.28 AM.png

]]>I am trying to keep a running tally of a profit / loss tracker for daily stock stuff. Everything is fine up till I enter a Withdrawl or Add a contribution.

-Everyday I go in and enter today's date along with the value of the account (Daily Start Net Liq), which is column B. If column B is greater than yesterdays column D, then the difference is profit. However, if I enter a withdrawal or a contribution the Profit and loss column is not accurate. The profit and loss in cell E3 is accurate, but from there on out it is not accurate. Below are the formula's currently used. Hope this helps explain.

Column D formula -=if(ISBLANK(B9),"",(C9+D9))

Column E Formula -=if(isblank(B10),"",abs(C10-E9-(sum($D$7:D10))))

If I add something in the withdrawal or contributions column I want to still be able to see my overall Profit and Loss, if that makes sense. Here is a screenshot of the table. Thank you.

Screenshot 2024-09-21 at 9.56.28 AM.png

Dear all,

Need what I believe to be a quick help in a google excel file, not sure how to build the formula I need.

Find attached the excell file that I download from google drive as an example.

I colored in yellow the head of the cells used in the calculation and in read the results I need with a manual exemple.

Thanks a lot in advance for any help on this regards.

Gisele

]]>Need what I believe to be a quick help in a google excel file, not sure how to build the formula I need.

Find attached the excell file that I download from google drive as an example.

I colored in yellow the head of the cells used in the calculation and in read the results I need with a manual exemple.

Thanks a lot in advance for any help on this regards.

Gisele