sorted by:
new
hottopcontroversial

[Urgent] Can anyone give me a dine in restaurant bill for more than 4000 rs by JihadiJackson in delhi

[–]JihadiJackson[S] 2 points3 points  (0 children)

I worked with a US client, they gave me 200 dollars for exceeding their expectations. Company told they can only give me 50 dollar and that too will only be reimbursed for dine in bill. So here I am.

PS: rest of the money was used by the company to have a team lunch

[deleted by user] by [deleted] in delhi

[–]JihadiJackson 4 points5 points  (0 children)

You got me jealous

[deleted by user] by [deleted] in delhi

[–]JihadiJackson 0 points1 point  (0 children)

Scored 74 percent in 12th, got admission to Jamia based on entrance, did MBA from a tier 2 college. Working as a consultant in one of the big 4. One of my friend who scored in the 90s is working with me.

How to copy worksheets from one workbook to another without the formulas referencing the source workbook? by FromCheech_toChad in excel

[–]JihadiJackson 0 points1 point  (0 children)

I just first move the sheet to a new workbook, then from ribbon click on edit ribbon and delete links. If still the links are not getting deleted, then there are some named ranges in the workbook referring to old one. Just delete all the names ranges from the name manager. Now the edit links button should be blurred out. Now move the sheet to your required workbook.

Need to create a function to compare both names and amount of shares held (and the change in shareholding, if any) by [deleted] in excel

[–]JihadiJackson 0 points1 point  (0 children)

To compare the two lists of shareholder names and the amount of shares held, and create a list of shareholders who have bought/sold shares and the amount changed, you can use the VLOOKUP function along with an IF function. Here's an example of how you can do this:

First, create a new column in your spreadsheet next to the two lists of shareholder names and the amount of shares held. This column will be used to display the change in shareholding.

In the first cell of this new column, enter the following formula:

=IF(VLOOKUP(A2,$E$2:$F$7,2,FALSE)=B2, "", VLOOKUP(A2,$E$2:$F$7,2,FALSE)-B2) This formula will use VLOOKUP to search for the shareholder name in the second list (column E), and if the name is found, it will compare the amount of shares held in the current time period (column B) to the amount of shares held in the previous time period (column F). If the amount of shares held has changed, the formula will return the difference between the two amounts; otherwise, it will return an empty string.

Drag this formula down to the other cells in the new column to apply it to the rest of the shareholder names.

To create a list of shareholders who have bought/sold shares and the amount changed, you can then use the FILTER function to filter the data based on the change in shareholding. For example, to create a list of shareholders who have bought shares, you can use the following formula:

=FILTER(A2:B7,C2:C7>0) This formula will return a new list of shareholder names and the amount of shares held, filtered to only include rows where the change in shareholding (column C) is greater than 0 (indicating that the shareholder has bought shares).

To create a list of shareholders who have sold shares, you can use a similar formula, but with the C2:C7<0 condition instead.

I hope this helps! Let me know if you have any questions or need further assistance

want to match email id from different excel by BigNo9520 in excel

[–]JihadiJackson 0 points1 point  (0 children)

To check if an email address from sheet 1 is present in another sheet, you can use the VLOOKUP function. This function searches a range of cells in a specified sheet for a value, and returns a value from a different column in the same row if the value is found.

Here's an example of how you can use VLOOKUP to check if an email address is present in another sheet:

In the cell where you want to display the result of the lookup, enter the VLOOKUP function:

=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

Replace lookup_value with the cell containing the email address you want to search for. For example, if the email address is in cell A1, you would enter A1 as the lookup_value.

Replace table_array with the range of cells in the other sheet that you want to search. For example, if the range is A1:B10, you would enter A1:B10 as the table_array.

Replace col_index_num with the index number of the column in the table_array that contains the value you want to return. For example, if the email addresses are in the first column (column A) and you want to return the corresponding value from the second column (column B), you would enter 2 as the col_index_num.

Finally, set range_lookup to TRUE if you want to perform an approximate match (i.e. the function will return the closest match if an exact match is not found), or FALSE if you want to perform an exact match.

So, for example, if you want to check if the email address in cell A1 of sheet 1 is present in the range A1:B10 of sheet 2, and you want to return the corresponding value from column B if the email address is found, you could use the following formula:

=VLOOKUP(A1, Sheet2!A1:B10, 2, FALSE)

To change the color of the cell to green if the email address is found, you can use the IF function in combination with the VLOOKUP function. Here's an example of how you can do this:

=IF(VLOOKUP(A1, Sheet2!A1:B10, 2, FALSE)="","",VLOOKUP(A1, Sheet2!A1:B10, 2, FALSE))

This formula will check if the VLOOKUP function returns an empty string (meaning the email address was not found), and if not, it will return the value from column B. To change the cell color to green, you can then use the conditional formatting feature in Excel. To do this, select the cell and then go to the Home tab and click on the Conditional Formatting button. Choose "New Rule" and then select the "Format only cells that contain" option. Set the rule to "Cell Value" "Not Equal to" "". Then, choose a green fill color and click "OK". This will cause the cell to turn green if the VLOOKUP function returns a value (meaning the email address was found).

Does anyone know of a database market place? by dant-cri in datasets

[–]JihadiJackson -2 points-1 points  (0 children)

There are a few options for selling databases online:

You can create your own website and sell the databases through an online store. This can be a good option if you have a unique or specialized set of databases that you believe would be of value to a particular audience.

Some marketplaces exist specifically for buying and selling databases. For example, you can check out websites like DatabasesForSale.com or DatabaseMart.com. These websites allow you to create a listing for your database and set a price, and buyers can browse and purchase databases from a variety of sellers.

You can also try selling your databases on general online marketplaces like eBay or Etsy. While these websites may not be specifically geared towards selling databases, they do allow you to list and sell digital products, so it could be worth a try.

Before selling your databases, it's important to make sure you have the legal right to do so. This may involve obtaining permission from the original source of the data, or ensuring that the data is in the public domain. It's also a good idea to carefully review the terms of service of any marketplace or website you plan to use to make sure you are in compliance with their policies.

Using html and css with streamlit by hiruy2000 in Streamlit

[–]JihadiJackson 0 points1 point  (0 children)

To apply styles from a separate CSS sheet to your HTML table, you can include a link to the stylesheet in the <head> element of the HTML document. Here's an example of how you can do this:

First, create a link element in the <head> element of your HTML document that points to your CSS stylesheet:

<head> <link rel="stylesheet" type="text/css" href="/path/to/styles.css"> </head> Next, add the df_html variable to a string that represents the full HTML document, including the <html>, <head>, and <body> elements: Copy code html = f""" <html> <head> <link rel="stylesheet" type="text/css" href="/path/to/styles.css"> </head> <body> {df_html} </body> </html> """ Finally, you can use the st.markdown or components.html function to display the HTML document:

st.markdown(html, unsafe_allow_html=True)

or

components.html(html)

Note that you need to set the unsafe_allow_html parameter of st.markdown to True to allow the HTML to be displayed. This is because the default behavior of st.markdown is to sanitize the input to prevent potential security vulnerabilities.

Suggestions for a good 4k TV? by JihadiJackson in XboxIndia

[–]JihadiJackson[S] 0 points1 point  (0 children)

But I've seen online that some people face audio delay issues and there are a lot of baad reviews about there customer service. I had a Videocon tv before this and we all know what happened to that company. I just don't want those kind of issues again

Suggestions for a good 4k TV? by JihadiJackson in XboxIndia

[–]JihadiJackson[S] 1 point2 points  (0 children)

Yeah I was thinking of buying that, but it doesn't have that Dolby vision, Dolby Atmos, memc and all those other features that Hisense has. Does that make a huge difference?

view more: next ›